Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PROCEDURE LOGINCHECK(SQLQRY IN CLOB)
- AS
- C INTEGER;
- N INTEGER;
- RC SYS_REFCURSOR;
- stmt clob:= To_Clob('begin ' || sqlqry || '; end;');
- BEGIN
- C := SYS.DBMS_SQL.OPEN_CURSOR;
- SYS.DBMS_SQL.PARSE(C,stmt ,DBMS_SQL.native);
- N := SYS.DBMS_SQL.EXECUTE(C);
- SYS.DBMS_SQL.GET_NEXT_RESULT(C,RC);
- SYS.DBMS_SQL.RETURN_RESULT(RC);
- EXCEPTION
- WHEN NO_DATA_FOUND THEN
- NULL;
- when OTHERS then
- RAISE;
- END LOGINCHECK;
- declare stmt clob := 'INWARDPKG.MACHINEINWARD_VALIDATING(XMLDOC => XMLTYPE.CREATEXML(paste xml from link))'; --The parameter value is a xml you can download it from above link
- begin
- LOGINCHECK(SQLQRY => STMT);
- end;
- PLS-00172: string literal too long.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement