Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Arguments Source

TEST_SQL

Arguments:

NameData TypeDefault ValueIn/Out
SQLSTRINGVARCHAR2 IN

Returns:

INTEGER(38.0)

Source

Source
     1: function test_sql (sqlstring IN varchar2) return integer
     2: AUTHID  current_user
     3: is
     4: 	cu	integer;
     5: begin
     6:     cu:= dbms_sql.open_cursor;
     7:     dbms_sql.parse (cu, sqlstring, dbms_sql.native);
     8:     dbms_sql.close_cursor(cu);
     9:     return 0;
    10: 
    11:     exception
    12:     when others then
    13:     return SQLCODE;
    14: end;


Generated by OraSchemaDoc, (c) Aram Kananov, 2002