Home » SQL & PL/SQL » SQL & PL/SQL » Prompting for value in create library statement
Prompting for value in create library statement [message #7993] Mon, 21 July 2003 09:57 Go to next message
Owen
Messages: 18
Registered: September 1999
Junior Member
I have the following code:

CREATE OR REPLACE LIBRARY TABLESPACE.NAME
AS 'c:oracleora90binora.dll';

Is there anyway to force it to prompt for the path of the DLL instead of harcoding it into the library?

Report message to a moderator

Re: Prompting for value in create library statement [message #8036 is a reply to message #7993] Tue, 22 July 2003 20:45 Go to previous message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
You could use a substitution variable:

CREATE OR REPLACE LIBRARY TABLESPACE.NAME
AS '&path';

Report message to a moderator

Previous Topic: Additional Query help
Next Topic: How to find wether procedure is running or not
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 12:04:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.