| plsql developer debuging [message #589498] |
Mon, 08 July 2013 00:52  |
 |
akhleshsingh2000
Messages: 1
Registered: May 2011
Location: NOIDA
|
Junior Member |
|
|
I HAVE A TABLE NAME IS BP_TYPE AND COLUMN IS
BP_TYPE_ID, example '02'
BP_NAME example ,'ramy'
I want to say that in sql developer how to pass the value for debuging pl/sql recode which mentioed below please help me.
PROCEDURE maintain_bp_type(ib_bp_type_buf IN bp_type%ROWTYPE,
lv_bp_id IN bp_type.bp_id%TYPE,
op_error OUT VARCHAR2)
----------------------------------------------------------------------------
DECLARE
IB_BP_TYPE_BUF PL/SQL RECORD;
LV_BP_ID NUMBER;
OP_ERROR VARCHAR2(200);
BEGIN
IB_BP_TYPE_BUF := NULL;
LV_BP_ID := NULL;
ORAGTW11.MAINTAIN_BP_TYPE(
IB_BP_TYPE_BUF => IB_BP_TYPE_BUF,
LV_BP_ID => LV_BP_ID,
OP_ERROR => OP_ERROR
);
/* Legacy output:
DBMS_OUTPUT.PUT_LINE('OP_ERROR = ' || OP_ERROR);
*/
:OP_ERROR := OP_ERROR;
END;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
