Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Packages, Scope
It seems that owa_util.choose_date wants to return a value of type DATE into
some kind of variable (which is why it may be thinking it is a function).
Try setting some variable := owa_util.choose_date and the use the value in
the variable in your htp.tableData code.
Jason
petrolsoft_at_my-dejanews.com wrote in message
<6qnrr3$rvn$1_at_nnrp1.dejanews.com>...
>I'm creating a package for an Oracle-based webpage. I'm using Webserver
3.0.
>My problem is this: I'm trying to call the procedure OWA_UTIL.CHOOSE_DATE
>inside a table (HTP.TABLEDATA), and I'm getting the error, PLS-00222: No
>function with name 'CHOOSE_DATE' exists in this code. I then tried copying
>the CHOOSE_DATE code to my own package, but I received the same error.
Could
>this be because the OWA_UTIL package can't see the package I'm creating?
>But, but packages are under the same owner. Please help me. Here's the
>basic code:
>
>PROCEDURE add_sales
>IS
>BEGIN
> htp.bodyOpen( cattributes => 'BGCOLOR="#FFFFFF"');
> htp.formOpen( curl => 'myurl', cmethod => 'POST');
> htp.print( '<CENTER>' );
> htp.tableOpen('BORDER');
> htp.tableRowOpen;
>---> htp.tableData( owa_util.choose_date('date')); <---
>
>Thanks,
>
>Scott Taylor
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Aug 24 1998 - 21:25:02 CDT
![]() |
![]() |