Re: rename table with vb code

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Mon, 25 Feb 2002 01:59:40 GMT
Message-ID: <3C799AA9.8123CEB8@ci.seattle.wa.us>

From an Oracle standpoint you are trying to do something that is about the equivalent of standing in water while fixing the electrical. Why could anyone possibly need to create a table within a stored procedure in Oracle?

I can understand why you might need to in SQL Server or Access ... but this is no way to work with Oracle.

Daniel Morgan

Dave K wrote:

> 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 Sun Feb 24 2002 - 19:59:40 CST