Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to create a temp table within Stored Proc and then return it to the outside?

Re: How to create a temp table within Stored Proc and then return it to the outside?

From: Daniel Kwan <c266366430_at_hotmail.com>
Date: 24 Aug 2002 20:49:07 -0700
Message-ID: <f724a6c4.0208241949.58311adf@posting.google.com>


Thomas Kyte <tkyte_at_oracle.com> wrote in message news:<ak2qd5017l6_at_drn.newsguy.com>...
> that doesn't in fact compile (or it shouldn't, if it does -- the bug is that it
> compiled)
>
> You must use SQL types -- not plsql types -- in order to do this in sql.

Thanks a whole lot! I will try it Monday (don't have Oracle access from home :-> )

Daniel Kwan Received on Sat Aug 24 2002 - 22:49:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US