SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Feb 2012
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Calling an Oracle function from an ASP page

    What is the syntax for calling an Oracle function from a Classic ASP page?

    Thanks,
    Sean

  2. #2
    SitePoint Member
    Join Date
    Feb 2012
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This is how I call the function:
    Code:
    strSQL = "Call PkgName.ProcessMyPaymentTransaction (1234567,'Credit',0,'4111111111111111','06','14',0  .10,6000677,NULL,'Y')"
    Conn.Execute(strSQL)
    But I get an error message:
    Code:
    Microsoft OLE DB Provider for Oracle error '80004005' 
    
    ORA-06576: not a valid function or procedure name 
    
    /Secure1/pymtprocess.asp, line 28


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •