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;
END;
Thanks
Masoud Varjavandi
-----------== 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
