SQL & PL/SQL

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!

Compiling Package through Command Window.

939984May 27 2012 — edited May 28 2012

Hi
I am new to Oracle and need some help in compiling PL/SQL packages from SQL PLUS.

I have two files
1) An SQL file ----------Calculate1.sql
2) and package ----------Indentify.pck,sql

I tried the following

SQL > @Calculate.sql (this was succesfully executed)

SQL > @Indentify.pck.sql (throwed an error)
The package has about 2 procedure and 10 function calling from it.

Can somebody please help how to compile the package file from SQL PLUS command line?

Thanks
Vino

Edited by: 936981 on May 27, 2012 10:21 AM

Edited by: 936981 on May 27, 2012 10:22 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 25 2012

Added on May 27 2012

5 comments

4,217 views