you can do this using a sp in Oracle moreover you could pass the table name
as a parameter name to the procedure. However almost certainly you don't
want to. what is the underlying reason for creating the table using an SP in
the first place?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Dave K" <randave_at_optonline.net> wrote in message
news:e7Od8.37402$co1.6824229_at_news02.optonline.net...
> I use VB with ADO 2.5 to connect to a database that could be Access 2000,
> SQL Server, or Oracle. A stored procedure creates a table, and then I
need
> to change the name of that table.
>
> Is there a good way to do this in code, or can I do this with a
query/stored
> procedure for each database?
>
> Thanks!
>
> - Dave
>
>
Received on Mon Feb 25 2002 - 04:54:56 CST
