[WebDB 2.1.0.0.] [Oracle] Dynamic Pages

From: Marcin Goralski <gormar_at_poczta.wprost.pl>
Date: Wed, 8 May 2002 15:34:13 +0200
Message-ID: <3cd9299c$0$12222$4d4efb8e_at_news.be.uu.net>



Hi there,

trying to play with WebDB, as it's supposed to play a role in our intranet. Recently got quite disappointed with Dynami Pages. A page with following tag has been created :

<ORACLE>select * from task where id_person= :hr</ORACLE> This page can not be executed alone as the variable hr is not initialised/defined at the run-time.

So , a frame driver has been created that would use following SQL :

select person_name, 'user.page.show?p_arg_names=hr&p_arg_values=' || id_person from people order by person_name asc

Problems :

  1. frame driver can not compile the code, despite the fact that almost exactly same code is used as an example for Frame Driver (scott's schema), with the only difference it's pointing to dynamic page while the other points to a form.
  2. trying to invoke the page directly using URL :

http://mymachine:port/path/page.show_at_p_arg_names=hr&p_arg_values=10

returns error saying about incorrect number of parameters .

Describing the package user.page displays procedure show without any IN parameters in fact.

[Quoted] So , is it possible to pass the variable to Dynami Page in WebDB 2.1.0.0. ? Any answers welcome.

brgds

marcin

--
************************************************
I can speak Esperanto like a native ...
Received on Wed May 08 2002 - 15:34:13 CEST

Original text of this message