OraFAQ Forum: Server Administration » PL/SQL Records and variables

Home » RDBMS Server » Server Administration » PL/SQL Records and variables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PL/SQL Records and variables [message #374439]

Tue, 12 June 2001 05:58

kavithask
Messages: 34
Registered: March 2001
Location: London

Member

Hi,

I have a procedure which uses 30 different variables based on one or more tables. The variables are assigned values inside a cursor loop and few of the variables are populated with values from the cursor. The remaining variables have hard-coded values.

Does it matter, if I use individual variables or use a PL/SQL record? Do individual variables occupy more memory when compared to a single PL/SQL record? Is it more efficient to use PL/SQL records or PL/SQL tables for these?

Please let me know the best way of declaring these 30 odd variables.

Thanks
Kavitha

Report message to a moderator

Previous Topic:	Returing some thing like a "result set" from a Stored Procedure
Next Topic:	Re: Inserting date format into an Oracle table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 15:48:02 CDT 2024