Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to debug an API

799706Mar 20 2012 — edited Mar 20 2012
I want to debug an API procedure named vcar_customers_api.import_customer from SQL developer . Can any one of you please let me know what piece of code can serve my purpose?

//my code for API Call without debug is

Declare
v_cust.cust_name := 'Sunil';
v_cust.cust_number := '1111';
v_cust.profile_class_name := 'VHA OM';
--Ship To Address Details
v_site(0).addr1 := P_ADDRESS1;
v_site(0).addr2 := P_ADDRESS2;
v_site(0).addr3 := P_ADDRESS3;
v_site(0).addr4 := P_ADDRESS4;
v_site(0).city := P_CITY;
v_site(0).state := P_STATE;
v_site(0).postal_code := P_POSTAL_CODE;
v_site(0).country := P_COUNTRY;
v_site(0).site_use_code := 'SHIP_TO';
v_site(0).primary_flag := 'Y';
v_site(0).site_use_status := 'A';

Begin
API Call# vcar_customers_api.import_customer(v_cust, v_site);
End;



I am looking forward to receiving your replies. Thanks.

-Sunil
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2012
Added on Mar 20 2012
3 comments
208 views