We have updated our Privacy Policy and encourage you to read it by clicking here.

All product names are trademarks of their respective companies. E-mail or User ID. Keep me signed in.

Calling Oracle Procedure from dicajytuh.web.fc2.com only works the first 2 times - Stack Overflow

Business Intelligence C Languages Cloud Computing Communications Technology CRM Data Center Data Warehouse Database Emerging Technology and Trends Enterprise Architecture and EAI. ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management. SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows. TOPICS Database Hardware Networking SAP Security Web Design.

Ask a New Question.

What is difference between a PROCEDURE & FUNCTION ?

Home Invite Peers More Database Groups. Your account is ready. Solve problems - It's Free Create your account in seconds.

dicajytuh.web.fc2.com Tutorial (dicajytuh.web.fc2.com) : สอน dicajytuh.web.fc2.com เรียน dicajytuh.web.fc2.com เขียน dicajytuh.web.fc2.com ภาษา dicajytuh.web.fc2.com บทเรียน dicajytuh.web.fc2.com ในประเทศไทย

E-mail address is taken If this is your account, sign in here. Between 5 and 30 characters. No spaces please The Profile Name is already in use. Executing Stored Procedures in Oracle Using Vb. Hi Everyone, I am trying to execute a stored procedure which changes the password of the user using vb.

Open Dim myCMD As New OracleCommand myCMD. ExecuteNonQuery Catch x MessageBox.

ToString End Try Oraclecon. Close But I am getting error message on the line Execute non query. Popular White Paper On This Topic The Six Questions Every IT Leader Needs to Ask.

Mark this reply as the best answer? Choose carefully, this can't be changed.

dicajytuh.web.fc2.com - Quick Guide

It is redundant to ExecuteNonQuery. I removed EXEC, now I am getting different error.

CREATE OR REPLACE PROCEDURE SYS. Close End Sub ORA Missing or invalid passowrd s ORA I suspect you are adding quotes to your user and password strings unnecessarily, similar to adding the extra EXEC before. I tried even that. Then I tried adding parameters in different way i. Thanks a lot for quick replies. White Papers and Webcasts. Popular Top 5 Mobile Security Threats.

Related Evolution of End User Computing--Evolving to Better Meet I create procudures to standardize the adding of parameters.

THis may make your thing simpler for your as your proceed. Input ; AddSQLParameter ref sqlParams, "pDiscountId", OracleType.

Input ; return this. This thread has been closed due to inactivity. Start a new thread here. Discussions fii the data by using refcur procedure. Topics on Toolbox for IT. The SQL group is a forum where peers share technical expertise, solve problems, and discuss issues related to SQL Structured Query Language.