| Packaged procedure call from Form [message #84682] |
Fri, 16 April 2004 06:03  |
Chanchal
Messages: 2
Registered: August 2001
|
Junior Member |
|
|
I have changed the signatures of a packaged procedure to include an additional IN type of parameter with a default value. e.g.
PACKAGE TEST IS
PROCEDURE A(VAR_A VARCHAR2,
VAR_B VARCHAR2,
VAR_NEW VARCHAR2:='1' --New Parameter
);
END ;
PACKAGE BODY TEST IS
PROCEDURE A(VAR_A VARCHAR2,
VAR_B VARCHAR2,
VAR_NEW VARCHAR2 --NEW parameter
)
IS
--
--
END;
END;
---------------------------------------
One of my Oracle form is using this packaged procedure, so running that form without compilation error gave me ORA-4062 due to change of signatures of the dependant packaged procedure. I had recompiled the form. Now it does not give the ORA error but just hangs when it calls the changed packaged procedure and finally resulting in a core-dump.
I am using Forms6i. Any clue would be highly appreciated.
|
|
|
|
| Re: Packaged procedure call from Form [message #84701 is a reply to message #84682] |
Mon, 19 April 2004 04:21  |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
First of all, the signature in header part should be the same in both the procedures.
Secondly, it may be hanging because the proc is recursively calling another proc or the proc has gone into an infinite loop.
Let me know if someone gets the solution.
Raj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
