Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Native SQL Procedure Code

Former Member
0 Kudos

Hi All,

During analysis of an issue I cam across a native SQL procedure code .

Procedure Name : APS_ORDER_CHANGE .

I checked with my basis team and unable to find the code.

Basis team used the following queries to retrieve the procedure code.

SQL> select OBJECT_NAME, SUBOBJECT_NAME, OBJECT_TYPE, STATUS from user_objects where OBJECT_TYPE='PROCEDURE' and OBJECT_NAME='APS_ORDER_CHANGE';

no rows selected

SQL> select OWNER, OBJECT_NAME, STATUS from dba_objects where OBJECT_TYPE='PROCEDURE' and OBJECT_NAME='APS_ORDER_CHANGE';

no rows selected

SQL>

Can anyone please let me know where can I find the procedure code?

Thanks & Regards,

Shafivullah Mohammad

1 REPLY 1

Former Member
0 Kudos

Hi,

Take a look at the following OSS note 698400

hope it will help you..

Thanks & regards.