Re: Package Compilation Problem

• Post for FREE via your newsreader at post.usenet.com ****

"Quantarc" <info_at_quantarc.co.uk> wrote in message news:%yvEc.934$Fc7.217498_at_stones.force9.net...
> oh man it works! i have lots of other packages with procedures that use
> 'open mycur for' and the argument i gave there was always just a seelct
> statement, not in a string at all. and this always worked... is there
> any reason why this should have been different this time??
>
> anyways, thanx a lot for the help!
> :D
>
> rod.

Rod

You are right, I just check it! I'm used to this type of cursor only with dynamic SQL... therefore my answer...

The problem is probably that you cannot access the table OPS_HD_M with the user you use to create the package. Of course if a string is used as parameter the check is performed at runtime... therefore you have no error.

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=