[WebDNA] ORACLE STORE PROCEDURE out parameter problem

This WebDNA talk-list message is from

2009

It keeps the original formatting. numero = 104258
interpreted = N
texte = We have been able to successfully connect and query Oracle using [sql] inwebdna.We are trying to call a stored procedure unsuccessfully. Here is my code[SQL DSN=mydsn&username=myusername&password=mypassword&Statement=beginmyprocedure (000000001, DBTNAME); END;].my results [/sql]My stored procedure only has two parameters an IN parameter and an OUTparameter. I believe the problem is the OUT parameter. The procedurerequires an out parameter to return the value. When I assign a outparameter in my sample code (DBTNAME) I get an error that says I need todeclare DBTNAME. If I use [DBTNAME] instead it doesn't know what "[" is. Any help will be really appreciated.Art Associated Messages, from the most recent to the oldest:

[WebDNA] ORACLE STORE PROCEDURE out parameter problem ("Arturo Vargas" 2009)

We have been able to successfully connect and query Oracle using [SQL] inwebdna.We are trying to call a stored procedure unsuccessfully. Here is my code[SQL DSN=mydsn&username=myusername&password=mypassword&Statement=beginmyprocedure (000000001, DBTNAME); END;].my results [/sql]My stored procedure only has two parameters an IN parameter and an OUTparameter. I believe the problem is the OUT parameter. The procedurerequires an out parameter to return the value. When I assign a outparameter in my sample code (DBTNAME) I get an error that says I need todeclare DBTNAME. If I use [DBTNAME] instead it doesn't know what "[" is. Any help will be really appreciated.Art "Arturo Vargas"

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[WebDNA] Different results for [THISURL] (2018) [math] storage of variables (1997) Hiding the URL(was Cart ID Duplication) (2001) Tech question about web dna actions (1998) off-topic - printinglib 68K (1997) variables in or out of includes (2001) Web Catalog 2 demo (1997) sorting dates (1999) off topic - dna snipets (1997) New WebCatalog site (1997) First postarg not taking in $Commands (1997) Searching for Email Address (2004) Allowed fields in formulas.db (1998) trouble updating records in database (1998) emailer (1997) Cart vs database (1998) snicker, snicker (1997) New to WebCat, Help. (1998) Off Topic: Sound Clips (2003) [isfile] ? (1997)