tag:blogger.com,1999:blog-3381423006343962689.post7075671483165849538..comments2009-09-22T14:04:55.826-07:00Mark Mestetskiyhttp://www.blogger.com/profile/05916262470293449675noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-3381423006343962689.post-35277853531756444592009-09-22T14:04:55.826-07:002009-09-22T14:04:55.826-07:00

You most likely used just the function and skipped declare portion. Please include declaration of the variables in your module as well. If it is a package, then put it in the package spec.

Mark Mestetskiyhttp://www.blogger.com/profile/05916262470293449675noreply@blogger.comtag:blogger.com,1999:blog-3381423006343962689.post-87934415732627369002009-09-09T09:43:30.375-07:002009-09-09T09:43:30.375-07:00

Hi,<br /><br />I&#39;m trying to use it on oracle 9i but getting the compilation error &quot;identifier &quot;v_type&quot; must be decalared.<br />Thanks<br />Rahul

Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3381423006343962689.post-25134523708479027242009-07-16T13:52:53.367-07:002009-07-16T13:52:53.367-07:00

Not sure what was wrong. I tried it via TOAD ( very similar to SQL developer) and it worked. It should work in 9i. Please provide the error. Are you using the code exactly as it presented here or you did some alteration?

Mark Mestetskiyhttp://www.blogger.com/profile/05916262470293449675noreply@blogger.comtag:blogger.com,1999:blog-3381423006343962689.post-28281857081369655902009-07-06T15:12:55.286-07:002009-07-06T15:12:55.286-07:00

Hi<br /><br />I am quite new to Oracle. I&#39;ve pasted the above code into sql developer and it hadn&#39;t worked. Does it work on Oracle 9i?<br /><br />Thanks<br />Joyce

joyceschanhttp://www.blogger.com/profile/05397213268052599590noreply@blogger.com