|
-
how to use CURSOR in DBMS_SQL???
CREATE OR REPLACE PROCEDURE CreateTable(
p_Description IN VARCHAR2
)IS
v_CURSOR NUMBER;
v_CreateString VARCHAR2(100);
v_NumRows INTEGER;
BEGIN
v_Cursor := DBMS_SQL.OPEN_CURSOR;
v_CreateString := 'CREATE TABLE temp_table'||p_Description;
DBMS_SQL.PARSE(v_CURSOR,v_CreateString,DBMS_SQL.V7);
v_NumRows := DBMS_SQL.EXECUTE(v_Cursor);
DBMS_SQL.CLOSE_CURSOR(v_Cursor);
END;
Q1:What's mean of v_Cursor?how to define it?
Q2:what's value v_NumRows will get?
Q3:How to use loop by v_Cursor???
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
|