Solved

problem in procedure creation in Oracle

Posted on 2006-06-20
6
718 Views
Last Modified: 2008-01-09
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
Comment
Question by:novice_user
6 Comments
 
LVL 47

Expert Comment

by:schwertner
Comment Utility
Add Exception Handler in the procedure and catch the error that causes the error:


....
EXCEPTION
  when others then
   message(sqlcode || ' ' || sqlerrm);
0
 
LVL 16

Expert Comment

by:MohanKNair
Comment Utility
Close this form and open a new form and try the same thing.

0
 

Author Comment

by:novice_user
Comment Utility
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
 
LVL 47

Accepted Solution

by:
schwertner earned 500 total points
Comment Utility
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
 
LVL 1

Expert Comment

by:Computer101
Comment Utility
Forced accept.

Computer101
EE Admin
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now