Re: Setting Default Printers In ORACLE

James D. Smith (jdsmith_at_llnl.gov) wrote:
: Hello Oracle-ites,
: Before I go through a lot of analysis and coding effort, I'm wondering if
: anyone has developed a way for a user to select a default printer from
: within an Oracle form. An idea that we have is that a user would call up a
: small form with a scrolling field of available printers to choose from.
: They would then select the printer that they would like to use for their
: reports and this printer would continue to be their default printer until
: they accessed the form again and selected another printer.
 

: Has anyone done something like this before? If so, what did you do to
: accomplish this task?

 Yes, we've done this. At first everything was stored in a global variable  that forms would use. Later I believe we put everything into a packaged  procedure. The printer list was stored in the database itself, so we  didn't have dynamic choices. If we had to pass the printer number out  of the form, we passed it as a paramater (to a C program, most usually.)

 I'm sure others could probably come up with a better solution.
: James D. Smith
: Oracle Developer/DBA
: LLNL
: P.O. Box 808, L- 386
: Livermore, Ca. 94550
: (510) 424-6104

Chris

-- 
=============================================================
Chris Cebelenski                         cpc_at_shell.portal.com
Science Fiction SIG Moderator        Moderators SIG Moderator
Portal Communications                "It's the MOOG, man."