Package question

[insurancereports]

Hello everyone,

I need to create a package which will run five different sql scripts. There are no procedures or functions. Currently we run each sql script one by one, through a main sql script. But there is no way to insert any dbms_output, straight to sqlplus.

My main need right now, is to create a package that will comprise these five different sql scripts. Is this possible? I'm not sure how to write a package that does not have any functions or procedures. Please help.

thanks,
AM

 

[carp]

Is there any reason you can't use any functions/procedures? It seems like what you would want to do is create five procedures (one for each script) and then have a driver procedure that calls the other five.

Elbert, CO
1204 MST

 

[insurancereports]

Hello Elbert,

I did write procedures inside the package, and it runs fine from TOAD. But now, I am not able to run it from sqlplus. I have no idea why.

I am trying to run the package through a shell script
and am referencing the procedures correctly, but it's giving many errors.

I tried to run each procedure seperately from sqlplus
SQL> begin
2Pack1.proc1;
3end;
4/

and it provides the following error: Pack1.proc1 must be declared (on toad, it runs perfectly). Please help.

thank you,
AM