Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: using variables in pl/sql code???
Instead of
DBMS_OUTPUT.PUT_LINE('THE COLUMNS: ' || SAMPLE_SSAS_TABLE.NAMING);
put this line
DBMS_OUTPUT.PUT_LINE('THE COLUMNS: ' || SAMPLE_SSAS_TABLE.COLUMN_NAME);
Gocha
masoud.v_at_usa.net wrote in message <7g364n$kno$1_at_nnrp1.dejanews.com>...
>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:41:45 CDT