Hamid, Could you explain, what are the parameters of your function, specifically: 'code_column_name' (is it column name?) and 'code_id'.
Igor Neyman, OCP DBA [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 12:07 PM > Hi list, > > I have this function it's compile ok but doesn't return any value: > > CREATE OR REPLACE function f_get_desc2 > (table_name in varchar2, > code_column_name in varchar2, > code_id in varchar2) > return varchar2 > is > return_desc varchar2 (100) ; > DESC_VAL VARCHAR2(100); > > begin > SELECT COLUMN_NAME INTO DESC_VAL FROM USER_TAB_COLUMNS ????? > WHERE TABLE_NAME =':table_name' AND COLUMN_ID = 2 ; ???? > -- here I want to get the description column name from > user)tab_columns.....then get the value based on the ID > execute immediate 'select ' || DESC_VAL || > ' from ' || table_name || ' where ' || code_column_name || > ' = :id' into return_desc using code_id ; > return return_desc ; > end ; > / > > I pass column_name ,code & value of the code to function then get the name > of description Column from table_name and finally get the description based > on table_name,descripton column & value, BUT doesn't return any value > I am not sure but the ?mark lines doesn't return any value. > > Thanks for your help. > > Hamid Alavi > Office 818 737-0526 > Cell 818 402-1987 > > The information contained in this message and any attachments is intended > only for the use of the individual or entity to which it is addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from > disclosure under applicable law. If you have received this message in error, > you are prohibited from copying, distributing, or using the information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
