Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

substitution strings in select-statemtens

Christian RopposchOct 9 2008 — edited Oct 9 2008
ahoj!

is it possible to use a substitution string in a select-statement as db-link? if yes, how? for example:
application definition -> substitution string: DB_WORK, substitution value: pwork_pwork
how can i use the substitution string DB_WORK in a select-statement?

select * from test@DB_WORK should result in select * from test@pwork_pwork, but this doesn't work. v('DB_WORK'), &DB_WORK. and :DB_WORK is also not possible. (error message: Query cannot be parsed within the Builder...)

background: i have a test- and production-application. in the test-app i use pwork_pwork as db-link, the production-app should use work_work. the apex-database is for both environments the same.

thx!

bye,
christian

Comments

InoL

I do not know anything about BI Publisher, but I assume it has an option to send the output to a printer. Simply Googling for it:
Configure a Printer in Oracle Analytics Publisher
Browsers cannot send output directly to a printer. There is always some user interaction before sending the output to a printer.

Small print: there is a non-standard way to send some output directly to the printer from a browser. However, it involves hacking the Windows registry (I only know this trick for Windows):
Create a PDF file with extension .pdfp. Windows doesn't know this extension, so it will create a new registry entry for pdfp.
Change the Open behaviour in the registry (find it somewhere in \HKEY_CURRENT_USER\SOFTWARE). Instead of opening the file, print it. In my case, I use Sumatra pdf:

"C:\Users\someuser\AppData\Local\SumatraPDF\SumatraPDF.exe" -print-to-default "%1" %*

Of course, this command will change per configuration.

TexasApexDeveloper

If the print engine was NOT Bi Publisher, I'd recommend Apex Office Print. They have functionality to print to a network printer included with the product. Since this is a Bi Publisher question, you MIGHT get a better response if you posted it to that products support forum..
Thank you!
Tony Miller
White Rock, NM

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 6 2008
Added on Oct 9 2008
12 comments
505 views