oracle 11g package

I have from development two packages - I was told to run one and that the return value would be "1"
can you tell me how I check the return value to make sure the correct package script was executed?
LVL 1
bkreynolds48Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sventhanCommented:
Can you run the package and check the output?

Is it a oracle package?


in sqlplus use

set serveroutput on
then run the package to see the output.
0
bkreynolds48Author Commented:
so just log into sqlplus and do

set serveroutput on
@package_name;

right?
0
slightwv (䄆 Netminder) Commented:
@ runs a script file.

So if you have a file called package_name.sql, then @package_name would work.

Are you trying to execute the package or did development give you a script to actually create the package?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

bkreynolds48Author Commented:
they gave me script to run -
I ran the script in the database -
 now I need to know what the return value is -

 it is supposed to return a
"1" if  the p_checkoff.sql was run

and

 '0" if p_check.sql was run -

the package name is p_check
0
slightwv (䄆 Netminder) Commented:
If the script was to just create the package then you will have to check with the people that told you about the return value.

The package will either create or not create and should tell you immediately if it did or did not.

You should see a message like
Package created.
or
Warning: Package created with compilation errors.

I've never heard of a return code unless you are actually wanting the return value from sqlplus when you exit but I don't see the need here.
0
bkreynolds48Author Commented:
as far as I understand it
when the p_check package is created it returns a value of "0" to the application
when the p_checkoff script is run it creates the p_check package so that it returns a value of "1" to the application

does that make sense?
0
slightwv (䄆 Netminder) Commented:
>>does that make sense?

Nope.

Creating the package is different than calling a procedure/function inside the package.

The package being created doesn't return anything to any app.

The app can call a procedure/function inside the package that can return a value but it will NEVER return a value if the function/package doesn't exist.  It will return an error.
0
bkreynolds48Author Commented:
the package exists
can I return the value of the function inside the package?
function name is f_check
0
slightwv (䄆 Netminder) Commented:
select p_check.f_check  from dual;
0
bkreynolds48Author Commented:
I get
ora-06553 pls-306 wrong number or types of arguments in call to f_check
0
slightwv (䄆 Netminder) Commented:
You have the script that creates the package.

How is f_check defined?  If it has input parameters, you'll need to supply them...  and proper ones.

We cannot answer that for you.  You'll need to check with the developers.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bkreynolds48Author Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.