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

Home -> Community -> Usenet -> c.d.o.server -> Re: Packages, Scope

Re: Packages, Scope

From: Jason Archambeau <jason.archambeau_at_mci2000.com>
Date: Mon, 24 Aug 1998 22:25:02 -0400
Message-ID: <sZoE1.23$026.26411@news.mci2000.com>


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

Original text of this message

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