Re: Dynamic variable declaration in PL/SQL

You could probably set up a PL/SQL table and record type that you can initialize with the information in the parameters, including name and datatype. You may then reference them as you wish by table index.

Jerry.

Hard_Core_at_my-dejanews.com wrote:

> Hi,
>
> Is there any way to declare a variable number of variables (having no specific
> datatype) in a procedure or function?
>
> I'm trying to develop a proc that takes in a group of parameters and uses some
> of those parameters as variables.
>
> As far as I know, this isn't possible in PL/SQL. My boss still wants me to
> try.
>
> Thanks in advance for anything.
>
> Sam
>
> PS - I'm using a officemate's computer because I don't have access to the web.
> Please reply to (smullen at avantec dot net).
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Jul 24 1998 - 21:17:33 CEST