Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> using variables in pl/sql code???
Can somebody please tell me what's wrong with the following code??
CREATE OR REPLACE
PROCEDURE MEMO(SSAS_TABLE_NAME IN VARCHAR2)
IS
CURSOR SSAS_TABLE(SSAS_TABLE_NAME VARCHAR2) IS SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME=SSAS_TABLE_NAME; SAMPLE_SSAS_TABLE SSAS_TABLE%ROWTYPE; NAMING VARCHAR2(10); BEGIN OPEN SSAS_TABLE(SSAS_TABLE_NAME); FETCH SSAS_TABLE INTO SAMPLE_SSAS_TABLE; NAMING:='COLUMN_NAME'; DBMS_OUTPUT.PUT_LINE('THE TABLE ' || SSAS_TABLE_NAME); DBMS_OUTPUT.PUT_LINE('TESTING NAME ' || NAMING); DBMS_OUTPUT.PUT_LINE('THE COLUMNS: ' || SAMPLE_SSAS_TABLE.NAMING); CLOSE SSAS_TABLE;
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 26 1999 - 21:07:21 CDT