|
-
How can I test a procedure with SQL plus. What is the command?
ex:
CREATE OR REPLACE PROCEDURE add_status
(status_code CHAR,
status_desc_e VARCHAR2,
status_desc_f VARCHAR2
) IS
cSQL_Statement VARCHAR2(200);
BEGIN
cSQL_Statement := 'INSERT INTO E_SIA_STATUS ' ||
' VALUES(:code, :desc_e, :desc_f)';
EXECUTE IMMEDIATE cSQL_Statement
USING status_code, status_desc_e, status_desc_f;
EXCEPTION
WHEN OTHERS THEN
RAISE_APPLICATION_ERROR(-20101,
'Error in procedure Add_status.');
END add_status;
/
How execute this procedure wtih SQL plus?
Thanks in advance
DONTBSHY
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|