Home » SQL & PL/SQL » SQL & PL/SQL » runtime table type
runtime table type [message #335649] Wed, 23 July 2008 02:34 Go to next message
sandipshahare
Messages: 21
Registered: March 2008
Location: Pune
Junior Member
Declare

my_samp ops$tester.abtt_method;

Begin
........
......
.......
.......
End;


In this, my_samp is a table type variable. I want to change this dynamically. By passing "ops$tester" value as IN parameter to the procedure. Like ops$user1,ops$user2 etc.

Is it possible to change this datatype at runtime?

Please response to this query.
Re: runtime table type [message #335651 is a reply to message #335649] Wed, 23 July 2008 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, it is not possible.
What is the actual need? Maybe you address it the wrong way.

Regards
Michel
Re: runtime table type [message #335653 is a reply to message #335649] Wed, 23 July 2008 02:49 Go to previous messageGo to next message
sandipshahare
Messages: 21
Registered: March 2008
Location: Pune
Junior Member
We want to execute a stored procedure through a VB script.
Here ops$tester is a owner of the schema.we want to use this procedure for different owners not users.
Re: runtime table type [message #335656 is a reply to message #335653] Wed, 23 July 2008 03:03 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a procedure in each schema as there is a table or type in each one.
Or if the table type is the same in each schema, you don't have to prefix it by the schema name.

Regards
Michel

[Updated on: Wed, 23 July 2008 03:04]

Report message to a moderator

Previous Topic: Execution Monitoring
Next Topic: passing parameters to SQL file through shell scripts
Goto Forum:
  


Current Time: Sun Dec 04 20:34:58 CST 2016

Total time taken to generate the page: 0.10152 seconds