[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] in webdna. We are trying to call a stored procedure unsuccessfully. Here is my code [SQL DSN=mydsn&username=myusername&password=mypassword&Statement=begin myprocedure (000000001, DBTNAME); END;] .my results [/sql] My stored procedure only has two parameters an IN parameter and an OUT parameter. I believe the problem is the OUT parameter. The procedure requires an out parameter to return the value. When I assign a out parameter in my sample code (DBTNAME) I get an error that says I need to declare 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:

    
  1. [WebDNA] ORACLE STORE PROCEDURE out parameter problem ("Arturo Vargas" 2009)
We have been able to successfully connect and query Oracle using [SQL] in webdna. We are trying to call a stored procedure unsuccessfully. Here is my code [SQL DSN=mydsn&username=myusername&password=mypassword&Statement=begin myprocedure (000000001, DBTNAME); END;] .my results [/sql] My stored procedure only has two parameters an IN parameter and an OUT parameter. I believe the problem is the OUT parameter. The procedure requires an out parameter to return the value. When I assign a out parameter in my sample code (DBTNAME) I get an error that says I need to declare 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:

Math Function (1997) syntax question, not in online refernce (1997) emailer cc to figured out (1997) Logical and or in [hideif] (1997) Virtual hosting and webcatNT (1997) [WC 2.1.30] Stack overflow. (2000) Bug Report, maybe (1997) [WebDNA] Apache 2 Error Log Entry (2009) Help- Spam Bots are spamming my site. (2007) Web Catalog 2 demo (1997) Quickie question on the email templates (1997) See [shell]s (2008) Writefile (2000) Logging purchases (1997) math variable security (2000) [WebDNA] CICADA (2008) Running _every_ page through WebCat ? (1997) To Use Cookies or Not To Use Cookies (2003) OT: Urgent help with Windows and Javascript (2003) A dynamic database. (1997)