calling a pl/sql procedure from sqldeveloper

by Euo 1. August 2008 15:17
I better write it here.

SET SERVEROUTPUT ON
DECLARE
L_COUNT NUMBER(38);
L_COUNTVALUE NUMBER(38);
L_FREE_RECORDS NUMBER(38);
L_TOTAL_RECORDS NUMBER(38);
L_OTHER_USER VARCHAR2(20);
BEGIN
EDGClaims.CountDocs
    ('12345',
     '20',
     'euo',
     L_COUNT,
     L_COUNTVALUE,
     L_FREE_RECORDS,
     L_TOTAL_RECORDS,
     L_OTHER_USER
    );
DBMS_OUTPUT.PUT_LINE('X'||L_OTHER_USER||'X');
END;

Tags: ,

Development

About the author

Something about the author

Month List

Page List