Search Again: Re: new From: Gustavo Guitera V.I.A. Date: Tuesday, December 16, 2003 Time: 12:20:13 pm what do I do wrong? CREATE OR REPLACE FUNCTION GETUSERS( V_USER IN NCHAR) RETURN CURSOR AS V_TORETURN CURSOR; BEGIN SELECT * INTO V_TORETURN FROM USERS WHERE USR_ID=3DV_USER; RETURN RESULT; END; Warning: Function created with compilation errors ----- Original Message ----- From: Gustavo Guitera V.I.A. To: Oracle List Sent: Tuesday, December 16, 2003 11:10 AM Subject: Re: [Oracle] new ok, i will prove it, thanks a lot. ----- Original Message ----- From: Fabien Sanglard To: Oracle List Sent: Tuesday, December 16, 2003 10:48 AM Subject: Re: [Oracle] new In this case, i think you can return a cursor ( just declare V_TORETURN in my exemple as cursor).. CU ----- Original Message ----- From: Gustavo Guitera V.I.A. To: Oracle List Sent: Tuesday, December 16, 2003 2:24 PM Subject: Re: [Oracle] new thanks for the answer, but I need to return all the records of one table in which records have the same where conditions. for example IN parameter =3D Wuser_country select * from users where usr_country=3DWuser_country thanks, again ----- Original Message ----- From: Fabien Sanglard To: Oracle List Sent: Tuesday, December 16, 2003 9:55 AM Subject: Re: [Oracle] new Yes, it is possible with stored function, this is an example: CREATE OR REPLACE FUNCTION GETMEDIAPATH( V_MEDIAID IN NUMBER) RETURN VARCHAR2 AS V_TORETURN VARCHAR2(255); BEGIN SELECT MYFIELD INTO V_TORETURN FROM YOURTABLE WHERE blablabla; You can here process any test or string treatment, RETURN RESULT; END; Cordialement, Fabien Sanglard ----- Original Message ----- From: Gustavo Guitera V.I.A. To: oracle-list@digitalpoint.com Sent: Tuesday, December 16, 2003 1:49 PM Subject: [Oracle] new Hi , I'm new using Oracle , and I have a lot of questions. 1- In a MSSQL I have store procedures whos return data like a simple query(select * from bla bla bla) , is that posible in Oracle? Which is the better way to solve that kind of troubles? thank in advance, Gustavo Guitera VAI - INGDESI Automation Albarellos 2620 - (C1419FSQ) Buenos Aires - Argentina Tel: +54-11-45732233 / Fax: +54-11-45732255 www.vai-ingdesi.com

Messages In This Thread: new by Gustavo Guitera V.I.A. on Dec 16, 2003 at 4:42:50 am Re: new by Fabien Sanglard on Dec 16, 2003 at 4:58:31 am Re: new by Gustavo Guitera V.I.A. on Dec 16, 2003 at 5:17:50 am Re: new by Fabien Sanglard on Dec 16, 2003 at 5:51:32 am Re: new by Gustavo Guitera V.I.A. on Dec 16, 2003 at 6:03:50 am Re: new by Gustavo Guitera V.I.A. on Dec 16, 2003 at 12:20:13 pm Re: new by Sanjay Rane on Dec 16, 2003 at 12:30:20 pm Re: new by Fabien Sanglard on Dec 17, 2003 at 12:04:26 am