Re: core dumps and packaged procedures

Can you try the following things

Logon to the Oracle user who owns the stored procedure and issue the following command

 select status
 from user_objects
 where object_name = 'your stored procedure name'

If status = INVALID then compile the procedure

   alter procedure <procname> compile;

Reissue the select statement and check if the status is VALID. Compile your forms application and re-run .

If this does not solve the problem, try executing the stored procedure from SQL*PLUS by supplying the same inputs which you supply through forms.

If still it fails, then edit your stored procedure, put some debug statements using dbms_output.put_line and re-run the procedure

By doing the above, you can get a rough idea about the behavior of the procedure.

Regards

N.Prabhakar
Socgen Crosby Securities
Singapore Received on Sat Nov 09 1996 - 00:00:00 CET