| urgent [message #39172] |
Sun, 23 June 2002 15:08  |
bharat
Messages: 11
Registered: February 2000
|
Junior Member |
|
|
Hi,
Iam coding a proC program where i call a stored proc
iam passing a variable to the stored proc as char
status = 'FIRST' || 'SECOND' depending on the condition
my stored proc logic works fine when i executed the stdproc from sql.
but when i call it from my proC program it not doing what its supposed to do.
--My proc program
if(retval = 0)
strcpy(status, 'FIRST');
else
strcpy(status, 'SECOND');
mypack.myprocedure(
status IN CHAR)
if (status = 'FIRST') then
begin
insert
elsif (status = 'SECOND') then
update.
can any one give me a suggestion, thanx
end;
end if;
|
|
|
|
| Re: urgent [message #39178 is a reply to message #39172] |
Mon, 24 June 2002 12:29  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
simply add some debug code to your stored proc to write your parameter values to a debug table when you call it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
