Hi all,
I need use dinamic string for my cursor... My code is:
query varchar := 'field1, field2 from ''' || tableName ||''' ........;
//has dinamic params
then I create cursor...
myCursor CURSOR FOR SELECT query;
I compile my function but when i run it I obtain error...
ERROR: invalid input syntax for integer: ......
CONTEXT: PL/pgSQL function "my_function" line 72 at FETCH
If I use static string, I don't have problems!!!
Can I solve it?
Thanks in advance
--
Luca Santaniello
email: luca.santaniello.81@gmail.com
skype: luca.santaniello
msn: luketto81@hotmail.com