Re: How to pass a table name into procedure ?

Sorry for bothering you, but I'm really fresh in Oracle, so I didn't catch your hint. Could you correct my procedure to make it valid one (I mean put valid code instead of '...'):

CREATE PROCEDURE QQ(table_name IN ...)
BEGIN
INSERT INTO table_name VALUES (1,2,3);
END; I don't need to define a cursor when my query doesn't return any data, do I ?
Thanks
Mariusz

Tak poza kadrem - na pewno jestem Ci winny piwo, wiec jesli jestes w Warszawie i masz ochote, to daj znac.
Mariusz
Marcin Buchwald wrote in message <39E43186.E4ABBF9F_at_gazeta.pl>...
>
>use native dynamic sql
>
>CREATE PROCEDURE QQ(table_name IN ..., retCur IN OUT)
>...
>open retCur for
>'SELECT * FROM '||table_name ;
>
>
>majapu_at_poczta.onet.pl wrote:
>>
>> I'd like to pass a table name into procedure, for example
>>
>> CREATE PROCEDURE QQ(table_name IN ...)
>> ...
>> SELECT * FROM table_name ;
>> ...
>>
>> How to do that ?
>> Thanks
>> Mariusz
Received on Wed Oct 11 2000 - 06:09:53 CDT