Home » SQL & PL/SQL » SQL & PL/SQL » Execute .lib at in Oracle (10.2.0.3.0)
Execute .lib at in Oracle [message #395013] Tue, 31 March 2009 01:17 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Hi All,

I have created a package. I saved it as PACK_IND_CA.lib in UNIX.
Now I am trying to execute this as
#sp user/pwd@host
sql>exec PACK_IND_CA.lib


I am trying execute as bove. But I am getting invalid identifier message.Can any one please let me know the process to execute .lib files as SQL prompt.

Thank you
Re: Execute .lib at in Oracle [message #395018 is a reply to message #395013] Tue, 31 March 2009 01:39 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Use the HOST or ! as command

ex.
SQL>!ls

[Updated on: Tue, 31 March 2009 01:39]

Report message to a moderator

Re: Execute .lib at in Oracle [message #395021 is a reply to message #395013] Tue, 31 March 2009 01:55 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
To call and execute a sqlscript, use @
Exec is reserved to execute stored procedures.
Re: Execute .lib at in Oracle [message #395026 is a reply to message #395021] Tue, 31 March 2009 02:18 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Thank you... It got resolved....
Re: Execute .lib at in Oracle [message #395036 is a reply to message #395026] Tue, 31 March 2009 02:40 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Do you really want to say that after working with Oracle for more than a year, you did not know how to call a sqlscript?
See? That is why we told you over and over to stop trying to learn every GUI-tool available and first get to the basics.
Previous Topic: How to fetch time interval
Next Topic: oracle temp tables or normal tables
Goto Forum:
  


Current Time: Fri Dec 06 17:19:32 CST 2024