• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 751
  • Last Modified:

problem in procedure creation in Oracle

Hi Experts..
I want to create a procedure using oracle form builder but when i open the form builder and try to open/write a procedure under PL/SQL Stored program units  in Database objects node, it generates the error "PDE-PXC002 Program unit execution aborted due to unhandled exception(980)".

this happend after i executed the sqlproc.sql script.

what can be the reason..
0
novice_user
Asked:
novice_user
1 Solution
 
schwertnerCommented:
Add Exception Handler in the procedure and catch the error that causes the error:


....
EXCEPTION
  when others then
   message(sqlcode || ' ' || sqlerrm);
0
 
MohanKNairCommented:
Close this form and open a new form and try the same thing.

0
 
novice_userAuthor Commented:
I think u have misinterpretted my question.
Actually i want to create a procedure. for this purpose i open form builder...I expand the" Database objects" node...from there i expand my user node(e.g. if username is abc then i expand "abc" node)..from there i expand "PL/SQL Stored program units" node and then from there i want to open an already created procedure by double clicking on that procedure. As i double click on the procedure the error   "PDE-PXC002 Program unit execution aborted due to unhandled exception(980)" is generated.
I think the question will be much clear now
0
 
schwertnerCommented:
This seems to be an Forms Builder bug. The best way to overcome this situation is to download a new version of the software or to look for a patch.
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now