STORED PROCEDURES [message #38792] |
Wed, 15 May 2002 07:50 |
kiran
Messages: 503 Registered: July 2000
|
Senior Member |
|
|
I am new to Stored Procedures. I have been calling a stored procedure created by another user in one of my asp pages. SOMETIMES it gives me problems in that it returns a null value. I looked at the procedure and noticed that one of the input parameters is not completely defined. Here is the PARAMETER definition:
I_CUID in number,
I_ITID number,
IO_PERMIT_ID in out number,
O_PERMIT_PRICE out number
As you can notice ITID has not been defined as either an input or output parameter. Can this be a reason for the problems I am getting? If so, why does it work well sometimes? Thanks for the help.
|
|
|
Re: STORED PROCEDURES [message #38794 is a reply to message #38792] |
Wed, 15 May 2002 09:19 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
Any parameter that does not have IN, OUT, or IN OUT specified will default to IN - so this is not causing your problem. Most likely, there is some condition (data, code, etc.) that is causing your particular OUT parameter to be NULL.
|
|
|
|