DBMS_SQL -HELP....

From: <gayatribalaji_at_my-dejanews.com>
Date: Mon, 08 Feb 1999 21:45:25 GMT
Message-ID: <79nlti$m61$1@nnrp1.dejanews.com>

Hi,

I tries to run a PL/SQl block which creates a table. DECLARE

        v_cursor_id                     number;
        v_createtableString             varchar2(500);
        v_numrows                       integer;
BEGIN
        v_cursor_id := DBMS_SQL.OPEN_CURSOR;
        v_createtableString := 'CREATE TABLE Mytable(NAME varchar2(20),MYNUM
number(2))'
        DBMS_SQL.PARSE(v_cursor_id,v_createtableString,DBMS_SQL.V7.3);
        v_numrows := DBMS_SQL.EXECUTE(v_cursor_id);

EXCEPTION
        WHEN OTHERS THEN
                IF SQLCODE != -955 THEN
                        RAISE;
                ELSE
                        DBMS_OUTPUT.PUTLINE('TABLE ALREADY EXSISTS');
                END IF:
        DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

END;
/

It gives me a error message BIND VARIABLE "DBMS_SQL" not declared. Can anyone help me in this...

Thanks,
gayatri

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 08 1999 - 15:45:25 CST