Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> using variables in pl/sql code???

using variables in pl/sql code???

From: <masoud.v_at_usa.net>
Date: Tue, 27 Apr 1999 02:07:21 GMT
Message-ID: <7g364n$kno$1@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:07:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US