Re: PL/SQL Questions

> 1. For my application end (both VB and Java), besides returning
> resultsets (from table) using cursors, how could I possibly return
> values that I defined personally e.g.
> returning 'doc', c2 records rather than selecting specifically from
> columns c1 , c2 from table.

don't know...

> 2. Just to check whether my way of coding PL/SQL statements is correct?
>
> My question is whether it is efficient or needed to define the cursor
> twice, once in the package header and another time in the function
> itself.

no

> Also is using function this way better or using a procedure with IN OUT
> settings

it depends, I've been working at VB project as a pl/sql-developer finding me wrapping functions with procedures as the VB developers couldn't access the functions... it's a bad solution though. I think when something primarily returns a value it should be a function, when something primarily "does something" it should be a procedure.

Help, that helped a bit

Thomas Received on Mon Aug 02 1999 - 17:37:55 CDT