[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to connect oracle package using ASP

Posted on 2009-04-24
3
Medium Priority
?
393 Views
Last Modified: 2013-12-18
I do not have any experience in Oracle. I usually send my data into Access but  this app needs to go into Oracle. I have an Oracle procedure that I send my variables from an ASP form. My form has 7 variables and I sent just two to see if it works and it does. The code attached works with a procedure.

The problem I have is that I will need to attach to an Oracle package instead. The DBA has taken the working procedure and put it in a package.  
The package name is testasp2.insert_name.
I have 2 inputs: stvlendcode & stvlenddesc
I have 1 output: p_result
Set Conn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
Conn.Open "DSN=abcd;uid=username;pwd=pwd"
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = Conn
cmd.CommandType = 4
cmd.CommandText = "insert_name"
 
Set puser = cmd.CreateParameter("stvlendcode", 200, 1, 10, xusername)
Set ppass = cmd.CreateParameter("stvlenddesc", 200, 1, 30, xpassword)
cmd.Parameters.Append puser
cmd.Parameters.Append ppass
cmd.execute()

Open in new window

0
Comment
Question by:jcuWM
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
prachwal earned 2000 total points
ID: 24235820
0
 

Author Comment

by:jcuWM
ID: 24281954
Found 2 things out. First , the output was added as a variable and appended and secondly, the rights to the user of the DSN did not have sufficient rights.

It works now.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses
Course of the Month17 days, 16 hours left to enroll

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question