Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 29th, 2004, 05:19 PM
Registered User
 
Join Date: Jun 2004
Location: NOVI SAD, NOVI SAD, Yugoslavia.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default out parameter from procedure???

Hi,
How can I get out parameter from storage procedure(on Oracle) in Access?

Plese HELP?
Thanks!


 
Old July 5th, 2004, 01:26 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Though I don't have Oracle available to test this, you would need to create a pass-through query in Access with (I think) the following SQL syntax:

{Call PackageName.ProcName (?, {resultset 20, OutParam1, OutParam2, ...})}

or

EXEC PackageName.ProcName (?, {resultset 20, OutParam1, OutParam2, ...})

Then create a DSN using the ODBC driver for Oracle to use as the pass-through queries ODBC Connect Str property. I don't have the Oracle client components installed on my system so I can't create the DSN, but once created, the Connect Str property value would look like:

"ODBC;DSN=yourSystemDSN;Uid=yourUsername;Pwd=yourP assword"

HTH,

Bob



 
Old July 8th, 2004, 01:37 PM
Registered User
 
Join Date: Jun 2004
Location: NOVI SAD, NOVI SAD, Yugoslavia.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks, but I am still receve this message:

ODBC -- call faild
[ORACLE][ODBC][ORA]Ora-01008:
not all variables bound(#1008)

Can I my problem define on another way:
I use Access as a client, an Oracle as server.
I won to know when I executed procedure on Oracle, that
"she" do her job (some update or delete). And I wont it to know in Access, but I do not how?!


Sorry, my English is bad.
Regards





Similar Threads
Thread Thread Starter Forum Replies Last Post
usin g stored procedure with parameter Sheraz Khan ASP.NET 2.0 Basics 1 September 5th, 2007 12:27 AM
Query Parameter of a Stored Procedure tarang SQL Server 2000 4 July 25th, 2007 11:43 AM
@ parameter1 not a parameter in store procedure shoakat ASP.NET 1.0 and 1.1 Basics 1 June 1st, 2007 04:32 AM
How to pass a parameter to a stored procedure? MaxGay2 VB.NET 2002/2003 Basics 1 November 8th, 2006 02:48 PM
Passing a parameter value to Stored Procedure mcinar SQL Server 2000 9 October 3rd, 2004 09:42 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.