Logo

Advertisement

Databases :: Error Executing Oracle Package / Message ORA-06550: Line 1, Column 7

forums.asp.net

I'm getting this error and I am not able to resolve somehow. I have an ASP.Net application calling an Oracle Package and I am getting this error: "Message "ORA-06550: line 1, column 7: [code]....

View Answers
Very similar questions

Advertisement

Advertisement

Call Package Have Procedure In Oracle Using Oci Drivers? stackoverflow.com

I am calling oracle package having procedure using oci drivers. I am getting error as Warning: oci_execute() [function.oci-execute]: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GET_BRAND_MODEL_LIST' ORA-06550: line 1, column 7: PL/SQL: Statement ignored in /opt/lampp/htdocs/call.php on line 26 [code]....

Databases :: How To Execute An Oracle Stored Proc forums.asp.net

DECLARE CUR_EMP_BIR REF CURSOR; BEGIN dbname.EMPLOYEE_P.EMPLOYEEBIRTHDAYSEL ( CUR_EMP_BIR ); END; ORA-06550: line 2, column 19: PLS-00201: identifier 'CURSOR' must be declared ORA-06550: line 2, column 15: PL/SQL: Item ignored ORA-06550: line 5, column 45: PLS-00320: the declaration of the type of this expression is incomplete or malformed ORA-06550: line 5, column 3: PL/SQL: Statement ignored [code]...

Calling Oracle Stored Procedure In SSIS social.msdn.microsoft.com

Hi, � I'm using Execute SQL Task to call an Oracle stored procedure. The following is the error that I get. � Error: 0xC002F210 at Validate and Transfer Actuals, Execute SQL Task: Executing the query "{call RS2_RealProject_ETL.TransformLoadAction} " failed with the following error: "ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'TRANSFORMLOADACTION' ORA-06550: line 1, column 7: PL/SQL: Statement ignored". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. � SQL statement syntax: {call RS2_RealProject_ETL.TransformLoadAction} � Per my review of the Forums, I'm entering the SQL syntax correct that is as follow and also use parameter names in Oracle in ordinal method starting from 0. � I have three "input" and one "output" parameter for the stored procedure that they all are of type "NUMBER" in oracle and I've defined them in "Parameter Mapping" window of Excute SQL Task as "NUMERIC". � I'd appreciate your help. � Thanks, Reza �

Connecting Oracle With RS forums.databasejournal.com

I am having trouble using stored procedures with Oracle 9i in RS. I am getting the following error: Microsoft Development Environment An error occurred while executing the query. ORA-06550: line 1, column 7: PLS-00221:'SP_GET_STOCKS' is not a procedure or is undefined ORA-06550: line 1, Column 7: PL/SQL: statement ignored: and here's the code in the for the defined package and SP_GET_STOCKS: CREATE OR REPLACE PACKAGE Types AS TYPE ref_cursor IS REF CURSOR; END; CREATE OR REPLACE FUNCTION sp_get_stocks(v_price IN NUMBER) RETURN Types.ref_cursor AS stock_cursor types.ref_cursor; BEGIN OPEN stock_cursor FOR SELECT ric,price,updated FROM stock_prices WHERE price < v_price; RETURN stock_cursor; END; / Please note that I am just testing yet, although I have completed some repoting using SQL server database: If you have any idea please let me know. Thanks a bundle! Mahfooz

Databases :: Direct Download From BLOB Column? forums.asp.net

i need to download a file directly from a table's BLOB column . i used this procedure, but i got the error: SQL> exec download_blob; begin download_blob; end; ORA-06550: line 2, column 7: PLS-00905: object IFRSCD.DOWNLOAD_BLOB is invalid ORA-06550: line 2, column 7: PL/SQL: Statement ignored The code is: [Code]....

Databases :: PLS-00201: Identifier 'Schema.package' Must Be Declared? forums.asp.net

Intermittant problem. We get this error intermittantly. The logged in user has permission to execute this package. Sometimes we get this error, other times it fires successfully. We have tested, and we find that we can use the same arguments both successfully and not. The permissions are done through roles, and mostly we are not having any problems with other parts of the application where procs are being called through a package to which the user had been granted execute via a role. I've seen stuff about granting explicit permission instead of roles, but with a hundred or so users and a dozen or so roles, dealilng with explicit permissions would be a major headace. Besides, it mostly works just fine. ORA-06550: line 1, column 7: PLS-00201: identifier 'MODONOR2.LETTERS' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Replication From Oracle 10g R2 To SQL Server 2005 SP2 social.msdn.microsoft.com

Hello All, I created all the role and logins as described in oracleadmin.sql file and were able to query Oracle tables. But when I try to crate publisher on Oracle server from sqL server� I get the following error: ------------------------------------------------------------------------------------------------------------------------------- TITLE: Distributor Properties ------------------------------ An error occurred applying the changes to the Distributor. For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Management+Studio&ProdVer=9.00.3186.00&EvtSrc=Microsoft.SqlServer.Management.UI.DistributorPropertiesErrorSR&EvtID=ErrorApplyingDistributor&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: SQL Server could not enable 'oracle_dev' as a Publisher. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Failed to execute the HREPL.INITPUBLISHER request to Oracle Publisher 'ORACLE_DEV'. Verify that the Oracle package code exists on the Publisher, and that the replication administrative user account has sufficient permissions. Changed database context to 'master'. OLE DB provider "MSDAORA" for linked server "ORACLE_DEV" returned message "One or more errors occurred during processing of command.". OLE DB provider "MSDAORA" for linked server "ORACLE_DEV" returned message "ORA-06550: line 1, column 8: PLS-00201: identifier 'HREPL.INITPUBLISHER' must be declared ORA-06550: line 1, column 8: PL/SQL: Statement ignored ". Error: 7215, Sev: 17, State: 1, Msg: Could not execute statement on remote server 'ORACLE_DEV'. (Microsoft SQL Server, Error: 21651) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3186&EvtSrc=MSSQLServer&EvtID=21651&LinkId=20476 -------------------------------------------------------------------------------------------------------------------------------------------------------- I searched the web� and could not find any related info, where is this package can I run it manually? Any help appreciated.

How To Pass Null In Stored Procedures Of ORACLE From VB www.vbcity.com

Hi there,I want to execute a stored procedure having some parameters, the procedure is simply executing an insert query for a table, now I want to pass NULL value for some of the fields, I had tried this, but it gave the error-----------------execute SP_INS_CMN_CASH_RECEIPT_DET(1,1,0,50,'A',428086,'13-APR-2004',1,NULL,NULL,2,2004,'2312-1010-0082',1,9000,NULL,'N','N','01-JAN-2002','01-JAN-2002','N')----------------I had also left blank the values which I wanna to be NULL, The error is--------------BEGIN SP_INS_CMN_CASH_RECEIPT_DET(1,1,0,50,'A',428086,'13-APR-2004',1,,,2,2004,'2312-1010-0082',1,90*ERROR at line 1:ORA-06550: line 1, column 71:PLS-00103: Encountered the symbol "," when expecting one of the following:( - + mod not null others <an identifier><a double-quoted delimited-identifier> <a bind variable> avgcount current exists max min prior sql stddev sum varianceexecute cast trim forall<a string literal with character set specification><a number> <a single-quoted SQL string>The symbol "null was inserted before "," to continue.ORA-06550: line 1, column 104:PLS-00103: Encountered the symbol "," when expecting one of the following:( - + mod not null others <an identifier><a double-quoted delimited-identifier> <a bind variable> avgcount current exists max min prior sql stddev sum-----------------------------The stored procedure is attached as a .sql file.Please help.Thanking u in anticipationRGDSAmit 

Getting Error While Executing The Oracle Stored Procedure Fromvb www.vbcity.com

Hi,I am trying to execute a oracle stored procedure from vb using ADODB command. But it give's the following error.Run-time error '-2147217900(80040e14)'ORA-06550:line1, column 7:PLS-00201:identifier 'TESTPACKAGE.GETSPECNAMES' must be declaredORA-06550:line 1, column 7:ORA-06550:line1, column 7:PL/SQL: Statement ignored.Here is my stored procedure in oracle and vb code:/*Please note that I am not using specname variable in the procedure though I ma passing it*/Create or replace package TestPackageISCursor C1 is select specname from refdatpipespec;TYpe speccursor is ref cursor return c1%rowtype;Procedure GetSpecNames(specname in varchar,SpecnamesCursor in out speccursor);end testpackage;create or replace package body testpackageasprocedure GetSpecNames(specname1 in varchar,SpecnamesCursor in out speccursor)isbeginopen SpecnamesCursor for select specname from refdatpipespec;END GetSpecNames;END testpackage;/my Vb code:    Dim oConn As ADODB.Connection    Dim rs As ADODB.Recordset    Dim cmd As ADODB.Command    Set oConn = New ADODB.Connection    Set cmd = New ADODB.Command    oConn.Open "Provider=OraOLEDB.Oracle.1;OSAuthent=1;DistribTX=1;Data Source= SP3DV4;Schema=rkancharCDB"    cmd.ActiveConnection = oConn    cmd.CommandType = adCmdStoredProc    cmd.CommandText = "TestPackage.GetSpecNames"    cmd.Parameters.Append cmd.CreateParameter("specname1", adVarChar, adParamInput, 20, "abcd")    Set rs = cmd.Execute()while this procedure works fine in oracle sql*plus;by doingvariable c1 refcursorexec testpackage.getspecnames('gf',:c1)print c1 /* prints all the specnames in the table */ please help how I can get the results in a recordset into vb.Thanks in advance,radhi.

VB, ADO, Oracle, Stored Procedure Problem www.xtremevbtalk.com

I'm calling an Oracle stored procedure within a package from my program. In the Oracle DB, the package is a synonym in my schema to the actual package in the application schema.When I run the code as below, it bombs with an ORA-06550 Error, PLS-00306: wrong Number or types of arguments in call to "procedure name" mcmdDB.CommandType = adCmdStoredProc mcmdDB.CommandText = "package.procedure" Set mrsDB = mcmdDB.Execute()Yet, when I hardcode the schema of the app into the CommandText, the procedure works flawlessly. mcmdDB.CommandType = adCmdStoredProc mcmdDB.CommandText = "schema.package.procedure" Set mrsDB = mcmdDB.Execute()How do I get this to work w/o including the schema name? Theoretically, the synonym in the database should work. Do we need to create a public synonym rather than a non-public synonym to get this to work?Thanks,BDSL

Advertisement

Databases :: Error While Getting Record Set From The Stored Proc Of The Oracle forums.asp.net

i am getting this error while fetching select statement in oracle pl/sql proc... ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SP_CLASS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored My proc is like..PROCEDURE "SP_CLASS" ( iDec IN NUMBER := null, p_ICID in number := null, p_DATA OUT SYS_REFCURSOR) IS BEGIN if(iDec = 1) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS; else if(iDec = 2) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS where ICID = p_ICID ; end if; end if; END;

SQL --&> To Oracle Load Error www.dbforums.com

hi, getting ORA-01722: invalid number error when running SQL 2000 DTS to Oracle 10g. This package works fine currently in production which is SQL 2000 and Oracle 9i. We are going to 10g and in dev the DTS package giving us error: Unknown provider error. [OLE/DB provider returned message: [Microsoft][ODBC driver for Oracle][Oracle]ORA-01722: invalid number OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::InsertRow returned 0x80040e03: Unknown provider error.]. please help thanks

Databases :: Excel Upload Large Numbers Of Rows? forums.asp.net

i am trying to upload an excel to an oracle data base (10g xe) the excel has arround 46000 rows.I am getting the following error when i do a insert ORA-06550 string 1 line 1, PLS-00123: program too large (Diana nodes

Can't Contact With Remote Oracle Server?! forums.devshed.com

Who sucefully link to the remote oracle server using php? I can't run it! php 4.0.1pl2 oracle 8i web server: NES 3.6 Oracle is resident at another server,its sid is 'webdb' and service name is 'net.db.host.com' I set up oracle 8i client on the web server,and configure the netec which test ok. When I use tnsping and sqlplus,all works well, for example: tnsping net tnsping db tnsping db.host.com sqlpus scott/tiger@net But when I use php4 with oci8 support,all don't work! This is the example code and error message: source code: ---------------------------------------------------- <? putenv("ORACLE_SID=webdb"); putenv("ORACLE_HOME=/data/oracle/app/8.1.5"); putenv("NLS_LANG=american.america.US7ASCII"); $conn = OCIpLogon("scott/tiger@net.db.host.com",""); if(!$conn)$conn=OCIpLogon("scott/tiger@webdb",""); if(!$conn)$conn=OCIpLogon("scott/tiger@net",""); if(!$conn)$conn=OCIpLogon("scott@net.db.host.com","tiger"); if(!$conn)$conn=OCIpLogon("scott@webdb","tiger"); if(!$conn)$conn=OCIpLogon("scott@net","tiger"); if(!$conn)$conn=OCIpLogon("scott","tiger","net.db.host.com"); if(!$conn)$conn=OCIpLogon("scott","tiger","webdb"); if(!$conn)$conn=OCIpLogon("scott","tiger","net"); if($conn) echo "sucessful!"; else echo "<font color=red>Connect to database failed!"; ?> --------------------------------------------------------------- The error message : ---------------------------------------------------------------- Warning: _oci_open_server: ORA-12545: Connect failed because target host or object does not exist in /data/php/z.php on line 6 Warning: _oci_open_server: ORA-12545: Connect failed because target host or object does not exist in /data/php/z.php on line 7 Warning: _oci_open_server: ORA-12545: Connect failed because target host or object does not exist in /data/php/z.php on line 8 Warning: _oci_open_server: ORA-12545: Connect failed because target host or object does not exist in /data/php/z.php on line 10 Warning: _oci_open_server: ORA-12545: Connect failed because target host or object does not exist in /data/php/z.php on line 11 Warning: _oci_open_server: ORA-12545: Connect failed because target host or object does not exist in /data/php/z.php on line 12 Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name in /data/php/z.php on line 14 Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name in /data/php/z.php on line 15 Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name in /data/php/z.php on line 16 Connect to database failed! --------------------------------------------------------------------- This is the tnsnames.ora file on web server --------------------------------------------------------------------- # TNSNAMES.ORA Configuration File:/data/oracle/app/8.1.5/network/admin/tnsnames.ora # Generated by Oracle Net8 Assistant NET = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = db.host.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = net.db.host.com) ) ) -------------------------------------------------------------------- This is the listener.ora on the oracle server -------------------------------------------------------------------- # LISTENER.ORA Configuration File:/oracle/app/8.1.5/network/admin/liste # Generated by Oracle Net8 Assistant LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) (PROTOCOL_STACK = (PRESENTATION = TTC) (SESSION = NS) ) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.13)(PORT = 2481)) (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db.host.com)(PORT = 1521)) (PROTOCOL_STACK = (PRESENTATION = TTC) (SESSION = NS) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/app/8.1.5) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = net.db.host.com) (ORACLE_HOME = /oracle/app/8.1.5) (SID_NAME = webdb) ) )

Apache Php And Oracle bytes.com

I am trying to get php to work with oracle and apache. when I execute a script with ph that connects to an oracle database it seems to work. php without "oracle stuff" in apache seems to work. However when I try the script that connects to the database via the web I get messages like: OCISessionBegin: ORA-03106: fatal two-task communication protocol error in any ideas ? (does php not see the ORACLE_HOME and ORACLE_BIN environment variables ?)

ORA-03113 Via Linked Server With Ole DB Provider For ORacle social.msdn.microsoft.com

Hi all, I am using MSSQL2005 and created a linked server with Ole DB provider for ORacle to connect to Oracle. sp_tables_ex linked_server�� It shows the tables in oracle, however, it show error with selecting the oracle tables via the linked server, Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' reported an error.� [OLE/DB provider returned message: Unspecified error] [OLE/DB provider returned message: ORA-03113: end-of-file on communication channel ] OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBSchemaRowset::GetRowset returned 0x80004005:�� ]. Any Idea?� Thanks a advance. �

Oracle_home, Oci8 And Stored Procedure bytes.com

I'm having an irritating problem. I've got php installed with the compile-time flag --oci8=$ORACLE_HOME. I can make connections to the oracle db no problem. Updating, selecting etc. is all good. However, when I use a web page that calls a stored procedure: $stmt = OCIParse($conn,"begin :result := s30.fn_udicheck('$UDI'); end;"); OCIBindByName($stmt,":result",&$result,32); OCIExecute($stmt); I get the following error when viewing the php page in a browser with apache as the web server: Warning: ociexecute(): OCIStmtExecute: ORA-06550: line 1, column 7: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated My problem is related to the variable $ORACLE_HOME. When I cat my php file through php from the command line with $ORACLE_HOME set it works. When I unset $ORACLE HOME I get the error above. me> export .... declare -x ORACLE_HOME="/u01/app/oracle/product/8.1.7" .... me> cat myfile.php | /usr/bin/php * this works * me> unset $ORACLE_HOME me> cat myfile.php | /usr/bin/php * this now fails * I've set $ORACLE_HOME in httpd.conf, php.ini and in the script itself with putenv. I've also made sure the webserver uid (apache) has access to all files under $ORACLE_HOME. This all makes no difference. I've recompiled with LD_LIBRARY_PATH=$ORACLE_HOME/lib too.

Stored Procedure In Oracle From VB 6.0 Using ADO visualbasic.ittoolbox.com

I am using the the techniques from the following MS article to access data from Oracle using a stored procedure: http://support.microsoft.com/kb/q176086/.I have implemented the article exactly as depicted except the connection string. The stored procedure executes succesfully from Toad. Whe I try to run it from VB I get the following error message:[Oracle][ODBC][Ora]ORA-6550; line 1, column 29; PLS-00201: identifier 'SSN' must be declared ORA-6550; line 1, column 7;PL/SQL; Statement ignoredAny help would be appreciated.

Connection Problems To Oracle Database social.msdn.microsoft.com

Hi, ��� I have a package connecting to oracle database ,this was developed on 32 bit Windows OS now i moved the same to 64 bit OS and it fails to connect to oracle database. I have created system DSN and tested it was successfull. In my package i�am using �ado.net connection object ,I am using ODBC data provider.I select the Data source in the drop down��.provide user name and password� and when i hit on test connection it fails with the following message� Test connection failed because of error in initilizing the provider error[08004] [oracle][odbc][ora]ORA 12154 : TNS could not resolve the connect identifier specified [Error]IM006[Microsoft][ODBC driver manager] drivers SQL setconnectattr failed � Any help on this will be appreciated Note:-� even though the OS is 64 bit i am using 32 bit ODBC as BI studio can only access 32 bit odbc

Could Not Resolve Service Name visualbasic.ittoolbox.com

Hi,I am using Oracle 8.1.6 as backend. When I try to execute my VB application in one of the client (with Windows 98), it givesthis errorRun-time error '-2147467259 (80004005)'[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS: could not resolve service nameThough it works absolutely fine in my machine and other machines who have Windows NT.For connecting to Oracle, I use Provider=MSDASQL and DRIVER={Microsoft ODBC For Oracle}, the server name also matches withthe one in Tnsnames.ora.Any help on this!!!ThanksRajesh

Databases :: Cannot Rollback In A Distributed Transaction forums.asp.net

When I execute a stored procedure (Oracle) that generates a ROLLBACK, the application is returning this message: ORA-02074: cannot ROLLBACK in a distributed transaction ORA-06512 There isn't error when the stored procedure do a commit ! I have tried to use the Enlist parameter in the connection string but it failed. I'm using the .NET Managed Provider for Oracle (System.Data.OracleClient) and FrameWork 1.1. Is there a solution ? I don't want to remove the Rollback statements from my stored procedures.

Calling A Pl/sql Stored Procedure Using Ado www.xtremevbtalk.com

I have a pl/sql procedure AddClient stored on an oracle server. I want to be able to execute this procedure from a vb app. I have the following code:-_____________________________________Private Sub cmdStoProc_Click()Dim SQLStoProcSQLStoProc = "execute AddClient('Name')"conn.Execute (SQLStoProc)rs.RequeryMsgBox "record added"End Sub________________________________I get this error[Oracle][ODBC][Ora]ORA -00900 :invalid sql statementAny help would be gratefully received

Fetched Column Value Was Truncated social.msdn.microsoft.com

I have an Oracle table which contains a LONG column and I need to migrate the data from this table using SSIS to a table in SQLServer.� The column in SQLServer is defined as nvarchar(MAX).� This works until I changed the Oracle table to a view.� The columns in the view�are defined exactly the same�as the source table except that it uses a database link to point to the table in a different�schema. �When executing the data flow task using the view, it gives me the following error message - � SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "ORA-01406: fetched column value was truncated ". � The error�happens only on views with LONG column.� Views with only varchar or numeric data types work fine. � Why does it work with a table but not a view which contains a LONG column? � Any suggestion is greatly appreciated.

Oracle Stored Procedure ADO Problem www.xtremevbtalk.com

Below is the post written by my colleague (my comments are marked ****). The upshot is that we can call Oracle stored procedures so long as we define the Procedure input parameters using the (variable_name tablename.column%TYPE) method. As soon as we declare the input parameter using (variable_name VARCHAR2) the procedure is no longer recognised by ADO.Anyone familiar with this?=====================================================I am having problems running an oracle 8i stored procedure via VB 6.0using MSDAORA as the provider and ADO 2.6. The procedure compiles withno errors with SQL Navigator and can be called from within SQLNavigator with no problems.However when attempting to call this from VB the following erroroccurs:ORA-06550: line 1, column 7:PLS-00201: identifier 'PR_CHECKSUMWRAPPER' must be declaredORA-06550: line 1, column 7:PL/SQL: Statement ignoredFrom reading posts on other groups the oracle documentation this errorcan suggest that there are incorrect permissions to execute the storedprocedure. However I am connecting to the schema as the owner and have full permissions so this should not be a problem.**we have granted specific permissions**I have run many other oracle stored procedures from my applicationwith the same amount and type of parameters with no problems what soever, so it's extremely confusing as to why this procedure is causingan error. ** the other procedures in fact use %TYPE method**The VB code and PL/SQL are pasted below.-------------------------------------------------------------VB:Dim rsDataChangedRecordSet As RecordsetDim prmEntity As ParameterDim prmChanged As ParameterDim prmStart As ParameterDim comDataChanged As New Command'Add input parametersSet prmEntity = comDataChanged.CreateParameter("Entity", adVarChar,adParamInput, 10, sEntity)comDataChanged.Parameters.Append prmEntitySet prmStart = comDataChanged.CreateParameter("Start", adInteger,adParamInput, , iStart)comDataChanged.Parameters.Append prmStart'Add output parametersSet prmChanged = comDataChanged.CreateParameter("Changed", adNumeric,adParamOutput)comDataChanged.Parameters.Append prmChanged'ExecuteSet rsDataChangedRecordSet = comDataChanged.Execute(, ,adExecuteNoRecords)** at this point the error occurs---------------------------------------------------------------------------PL/SQL: PROCEDURE pr_checksumwrapper ( ientity IN VARCHAR2, istart_or_end IN NUMERIC, ochanged OUT NUMERIC ) AS /** Usage: Wrapper for checksum procedures. Need to wrap them dueto message that original checksum procs create which cause ADO to error? IN Parameters: Entity: 'PROGRAMMES', 'PROJECTS', 'BUDGETS' Start_or_End: 1 =start 0 =end **/ lentity VARCHAR2 (10); BEGIN lentity := TRIM (UPPER (ientity)); IF ientity.iientity = 'PROGRAMMES' THEN pr_programmeschanged (istart_or_end, ochanged); ELSE IF ientity.iientity = 'BUDGETS' OR ientity.iientity ='PROJECTS' THEN pr_projectschanged (istart_or_end, ochanged); ELSE RAISE checksumwrapper; END IF; END IF; EXCEPTION WHEN programmeschecksum THEN RAISE; WHEN projectchecksum THEN RAISE; WHEN OTHERS THEN RAISE checksumwrapper; END pr_checksumwrapper;This calls in turn the relevant procedure, we thought at first thismay be causing the problem but even with the line calling theprocedure commented out the calling procedure fails to execute

Error While Calling Oracle Stored Procedure! www.sqlteam.com

Hi pals, I am facing problems while calling Oracle stored procedure which has no parameters. I have used Microsoft OLE DB provider for Oracle. I have taken one Execute SQL task and set the SQLStatement as call procedurename I also set the IsStoredProcedure property to True for Execute SQL task. Is there any synatx problem? I am getting an error saying Error: 0xC002F210 at Call Sp, Execute SQL Task: Executing the query "(call sp_procname)" failed with the following error: "ORA-00928: missing SELECT keyword. I removed the curly braces for the SQL statement and again ran the Package, i am getting the below error Executing the query "call sp_procname" failed with the following error: "ORA-06576: not a valid function or procedure name Can anyone help me out on this regard! Thanks in advance

Error While Calling Oracle Stored Procedure From SSIS ! social.msdn.microsoft.com

Hi pals, I am facing problems while calling Oracle stored procedure which has no parameters. I have used Microsoft OLE DB provider for Oracle. I have taken one Execute SQL task� and set the SQLStatement as call procedurename I also set the IsStoredProcedure property to True� for Execute SQL task. Is there any synatx problem? � I am getting an error saying Error: 0xC002F210 at Call Sp, Execute SQL Task: Executing the query "(call sp_procname)" failed with the following error: "ORA-00928: missing SELECT keyword. I removed the curly braces for the SQL statement and again ran the Package, i am getting the below error Executing the query "call sp_procname" failed with the following error: "ORA-06576: not a valid function or procedure name Can anyone help me out on this regard! Thanks in advance.

Error Procedure Oracle VB www.xtremevbtalk.com

Hi:Please, i need some help.I have a Store Procedure (Oracle) and i call from a Visual basic .exe, this procedure insert into one table, but when inserted around 29000 registries, I get this error:[Oracle][ODBC][Ora]ORA -00900 :invalid sql statementThis procedure works fine normaly, but sometimes i get that error.This is de VB code:Private Sub Form_Load()Set oConnStorProc = New ADODB.ConnectionoConnStorProc.Open = "DSN=MYODBC;UID=MYUSER;PWD=MYPASS;"strSQL = CStr("proc_load_detail_list")oConnStorProc.Execute (strSQL)oConnStorProc.CloseSet oConnStorProc = NothingUnload MeEnd SubThe store procedure has exceptions for capture the errors.Thanks.

Oracle Stored Procedure Stops At 1,000 Recsets www.codeguru.com

There is problem with a stored procedure (Oracle 8) that inserts 2,500 recordsets into a table: Running the following code (using ADO 2.1) leads to an error "[Oracle][ODBC][ORA]ORA-00900: invalid SQL statement". Dim conn as new ADODB.Connection conn.Open "dsn", "uid", "pwd" conn.Execute ("test(199906,199906,'IST')") conn.Close set conn = nothing In SQL Plus then I find that 1,000 recordsets have been inserted. If I execute the procedure in SQL Plus, it works correctly.Anyone can help? Thanks, Anja

How To Connection To Oracle Dataase Using Oracle 9.2 ODBC Driver www.vbcity.com

I try to connect to the Oracle database using the Oracle in OraHome92 driver, the code is:Private Sub ConnectDB()   Dim sConn As String   Dim DB As String     Select Case cboEnviro.Text      Case "Production"         DB = "PROD"      Case "Testing"         DB = "TEST"   End Select      sConn = "Driver=(Oracle in OraHome92);" & "Data Source=" & DB & _                ";Uid=userid;Pwd=password;"   dbConn.Open sConnEnd SubI got the following error message:Run-time error '2147467259 (80004005)':[Oracle][ODBC][Ora]ORA12560: TNSrotocol adapter errorCan anyone tell me what wrong with this and how to fix the problem. Thanks.

Databases :: Trying To Connect To Oracle 10g Database Using ODBC Connection forums.asp.net

I am trying to connect to Oracle 10g database through ASP using ODBC connection. The connection string used is con.Open "DRIVER={Microsoft ODBC for Oracle};SERVER=xxxx;UID=xxxxx;PWD=xxxxx" This works when I tried creating a macro and also using a vbs script. When run through classic ASP it gives error on the connection.open line. Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve text for error ORA-12154 /TestSC/a.asp, line 23 The connection is opened when using Ora oledb con.Open "Provider=OraOLEDB.ORACLE;Data Source=xxxx;User Id=xxxx;Password=xxxx" I am using IIS 6.0 and Oracle 10g.

Oracle 7.3 And SSRS social.msdn.microsoft.com

I am wokring on HP9000 system which uses Oracle 7.3 version on it. I am creating a Procedure to get the results as a� REF cursor as suugested by this articale http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=382454&SiteID=1.� � ��������� If I�select Oracle as a datasource unfortunately I am getting this message " System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" and if I select ODBC as a datasource and trying to connect I am getting this message " ERROR [42000][Oracle][ODBC][Ora]Ora-00900: invalid SQL Statement�(SQLORA32.DLL)". � ����I created this procedure in side a package and I am calling it as Package.ProcedureName example: "UnAllocatedSSN.UnAllocatedMembersList " � Please help.�Deepak

Error In Crystal Report www.xtremevbtalk.com

I am Storing Images in Oracle 8i database in BLOB fieldBut when i Create the crystal report file the Following error occurs in Crystal Reports"ORA:00932:Inconsistent datatypes"and a second message shows"Error Detected by database dll"What are the causes of these errors please advise.I am using VB-Crystal Report-Oracle for my application

SQLExpress Linked Server To Oracle Express 10g social.msdn.microsoft.com

Trying to set up a development environment on an XP SP2 machine with an installation of SQLExpress and Oracle 10g Express.� Having been trying to create a Linked Server in SQL to access the Oracle EX database.� Have had no luck using either Oracle driver or Microsoft driver.� With Oracle driver get the following error on an openquery statement: select * from openquery(xe,'select top 1 * from HR.REGIONS') Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "OraOLEDB.Oracle" for linked server "xe" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "xe". I am mapping a Windows authenticated login to an Oracle login/password in the Linked Server setup.� I can connect to the Oracle database fine using Oracle tools.� Likewise, I can connect to SQL Server database just fine.� I have set up the linked server using the Oracle Service Name in the TSNAMES.ora file as the Data Source in SQL Server. ('XE')� What could I be doing wrong?� What else can I check? �

Can Use Database Link In Recordset Query? www.xtremevbtalk.com

Hello all, I have create a database link to in one oracle 8i server to other oracle 9i server, everything work fine if i implement some query in oracle db tool such as SQL Plus, but, when i pass the query which work in SQL Plus to recordset, an error occur..the error message is as shown:Run-time error '-2147217900(80040e14)'ORA-02041: client database did not begin a transactionMay i know what the reason of causing this error?The code that i use to connect to database is:Dim strConnectionString As StringDim strPassword, strUserName, strOraServiceName As StringDim strSQL As StringstrConnectionString = "Provider=OraOLEDB.Oracle.1;" & _"Password=" & strPassword & ";" & _"Persist Security Info=false;" & _"User ID=" & strUserName & ";" & _"Data Source=" & strOraServiceNameSet objADOConn = New ADODB.Connection objADOConn.Open strConnectionString objADOConn.CursorLocation = adUseClient strSQL = "select count(*) from tablename@databaseLinkName" Set objADORs = New ADODB.RecordsetSet objADORs = objADOConn.Execute(strSQL)Everything work fine if i not link to dblink in my SQL query, i had try disable MTS support in ODBC driver configuration, but it seem not working, i need to use database link in my SQL query in order to connect to other database's table, please help..

Oracle 7.3.4 And MTS ( COM And Database ) www.codeguru.com

When I'm trying to connect to our Oracle 7.3.4 database I get the following error message from a COM object running inside MTS." MicroSoft OLEDB Provider for ODBC drivers error '80004005'[MicroSoft][ODBC driver for ORACLE][Oracle] ORA-00000: normal, successful completion. "

ODBC forums.databasejournal.com

I get the follwing error when I try to link table in MS Access or try to connect to an oracle data source in a DTS Package. [ORACLE][ODBC ORACLE DRIVER][ORACLE OCI]ORA-12532: TNS:invalid argument. (#12532) [Microsoft][ODBC Drvier Manager] Driver's SQLSetConnectAttr failed (#0). I can set up the same datasource and connect to it on some machines but then on some others I get the above error. Any Ideas? Thanks

Connecting SSRS With The Oracle Database social.msdn.microsoft.com

Hi all, ������� I need to connect�with the Oracle Database for the Reports application. But i am unable to do the same.�I am�getting errors like �ORA-12514,ORA-06401 while trying it. (1) Please tell me about any extra settings need to be done in the listener.ora,tnsnames.ora for getting SSRS connected with the Oracle DB.� (2)�Tell me the format of the connection string to be used for the connection with the Oracle database. (3) Also which datasource has to used.. Oracle / Microsft OLEDB provider for Oracle for the Same. � Please help me with these issues. � With Thanks M.Mahendra � � � �

[Oracle][ODBC][Ora]ORA -00900 :invalid Sql Statement www.vbcity.com

I have a pl/sql procedure AddClient stored on an oracle server. I want to be able to execute this procedure from a vb app. I have the following code:-_____________________________________Private Sub cmdStoProc_Click()        Getway.ActiveConnection = conn        Getway.CommandType = adCmdStoredProc        Getway.CommandText = "OwGenGateway"               Getway.Parameters.Append Getway.CreateParameter("prscngdt", adDate, adParamInput, , Format(DTPClrngDate.Value, "dd-mmm-yyyy"))        Getway.Parameters.Append Getway.CreateParameter("log_fname", adNumeric, adParamInput, , JulianDay)        Getway.ExecuteEnd Sub_____________________________________I get this error[Oracle][ODBC][Ora]ORA -00900 :invalid sql statementAny help would be gratefully receivedEdited by - chakrapani on 8/27/2003 12:17:34 AM

Running A SSIS Package As A Job Error - With A Connection To An Oracle Database social.msdn.microsoft.com

Hi, � I have installed MS SQL Server 2005 and Service Pack 2�on a new�Windows 32-bit environment.� I also installed the 32-bit 10g client (the Administrator option).� The tnsnames.ora file is configured properly and I can tnsping to the Oracle database without any issues.� I have created a package in Visual Studio and it runs successfully when I execute the job manually.� I saved the package to the MS SQL Server and when I log into Management Studio to create a job for this package, I receive the following error: � Message Executed as user: xxxSYSTEM. ...rsion 9.00.3042.00 for 32-bit� Copyright (C) Microsoft Corp 1984-2005. All rights reserved.��� Started:� 10:42:37 AM� Error: 2007-10-10 10:42:37.28���� Code: 0xC0202009���� Source: x Connection manager "x.x"���� Description: SSIS Error Code DTS_E_OLEDBERROR.� An OLE DB error has occurred. Error code: 0x80004005.� An OLE DB record is available.� Source: "Microsoft OLE DB Provider for Oracle"� Hresult: 0x80004005� Description: "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.��� Provider is unable to function until these components are installed.".� End Error� Error: 2007-10-10 10:42:37.28���� Code: 0xC020801C���� Source: Data Flow Task OLE DB Source [18]���� Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.� The AcquireConnection method ca...� The package execution fa...� The step failed. I have created the package and logged into the server with the same ID to set up the job.� And I have set the ProtectionLevel property to "Don't Save Sensitive Data" since I know this has been an issue in the past when I tried automating the job.� I've four posts regarding this error message on the MSDN forums that aren't helpful at this moment - I'm hoping that someone will have found a solution since those posts.� Any suggestions are welcomed. � Thanks for your help! Sue

Databases :: ORA-01000 - Maximum Open Cursors Exceeded forums.asp.net

I have some problem according to nettiers generator.. i am using nettiers 2.3.0 to generate library for oracle datasource 10g. here is the error when i am using the library.. ORA-01000: maximum open cursors exceeded ORA-06512: at "EPROC.ADM_MENU_GETPAGED", line 40 ORA-06512: at line 1 Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OracleClient.OracleException: ORA-01000: maximum open cursors exceeded ORA-06512: at "USERXXX.ADM_MENU_GETPAGED", line 40 ORA-06512: at line 1 Source Error: [Code]....

ADO - Whats Wrong? Pls Have A Look www.vbforums.com

Greetings,What is wrong with the following code?Every time run it I get in the line an error message (see below)Code:Option Explicit' The database connection.Private m_Conn As ADODB.ConnectionPrivate Const CONNECT_STRING As String = "Provider=OraOLEDB.Oracle.1;Password=XXXX;Persist Security Info=True;User ID=XXXX;Data Source=XXXX"Public Function GetStatusSTR(ByVal vName As String, ByVal vPW As String) As IntegerDim rs As ADODB.RecordsetDim strSQL As String strSQL = "SELECT S.USER_Status FROM ST_USER_STATUS S, ST_USER_ACCESS A WHERE " strSQL = strSQL & "A.STATUS = S.USER_STATUS_ID AND A.USERNAME = '" & vName strSQL = strSQL & "' AND A.PASSWORD = '" & vPW & "';" Set rs = m_Conn.Execute(strSQL) If rs.RecordCount > 0 Then GetStatusSTR = rs(0) Else GetStatusSTR = 0 End If rs.Close Set rs = Nothing Exit FunctionEnd FunctionPrivate Sub Class_Initialize() ' Open the database connection. Set m_Conn = New ADODB.Connection m_Conn.ConnectionString = CONNECT_STRING m_Conn.OpenEnd SubPrivate Sub Class_Terminate() m_Conn.Close Set m_Conn = NothingEnd SubThe error message is RunTime Error "-2147217900 (80040e14)ORA-00911: strSQL containes the following value when Set rs = m_Conn.Execute(strSQL) is executing"SELECT S.USER_Status FROM ST_USER_STATUS S, ST_USER_ACCESS A WHERE A.STATUS = S.USER_STATUS_ID AND A.USERNAME = 'zzz13204' AND A.PASSWORD = 'admin';"Many thanks in advance

Write A Dynamic Sql Query That Fetches Data From Oracle 10g Database? www.vbforums.com

trying to write a dynamic sql query that fetches data from oracle 10g database. My Where criteria is giving me real problems but i guess it has to do with the oracle data format. The data column is a TIMESTAMP data type storing values like 25-JAN-09 07.06.01.000000000 AM. Am trying to get rows having the columns matching a specific date( ignoring the time values), my where looks like this WHERE to_date(COMPLY_RUN_DASHBOARD_DATE,'DD-MON-RR')='" & Now.Date & "'"i get the following error :CheckError ORA-01830: date format picture ends before converting entire input string

VB With Oracle 11g Using REF CURSOR NOT Working? stackoverflow.com

I am using Visual Basic 6 to connect to Oracle 11g.Yes, I can successfully connect to the database.The problem is to receive the recordsets from the database.I have created an oracle package like below: Package: CREATE OR REPLACE PACKAGE PKG_BASECODE AS TYPE T_CURSOR IS REF CURSOR; --// customer [code].... And I receive an error something about parameters.The error message is written in Korean language, so I cannot write straight away.

Insert Data To MSSQL Within Trigger From Oracle www.sqlteam.com

I created a link from Oracle to SQL server. There is a trigger with insert statment in Oracle side. I got error message as follow when trigger is invoked: SQL> insert into test1 values ('zerbra','brazi'); insert into test1 values ('zerbra','brazi') * ERROR at line 1: ORA-02047: cannot join the distributed transaction in progress ORA-06512: at "GGWEB.TRIGGER2", line 4 ORA-04088: error during execution of trigger 'GGWEB.TRIGGER2' my simple trigger is as follows: create or replace TRIGGER TESTRI AFTER INSERT ON TEST1 FOR EACH ROW BEGIN insert into test1@sqlserver (city,state) values ('what','nine'); END;

Error Creating Report Model Based Upon Oracle Database social.msdn.microsoft.com

In MS Visual Studio, when creating a new Report Model Project, after defining a datasource to an Oracle database (and successfully testing it), and a simple datasource view (1 table), when I click "Run" in Report Model Wizard, I receive the following error: "ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }" It does not appear that one can create Report Models from an Oracle database (since the SQL being used to query the Oracle database cannot be�edited and contains syntax errors?). Is this the case? Thank you. � � �

Can't Decrypy The Child Package? social.msdn.microsoft.com

I had a child package AAA The ProtectLevel of AAA is "EncryptAllWithPassword" and�PackagePassword�is "passtest" � now I put a Execute Package Task on Control Flow TAB of Package BBB in this task I want to Execute package AAA,after set Password�"passtest" of Execute Package Task ,I execute package in command line DTExec.exe /F BBB.dtsx � I get error message, can't decrypt package AAA � Where can I set the PackagePassword�of AAA� in Execute Package Task. �

Sql - Return A 'DESC Package' Using OCI stackoverflow.com

I am trying to get information on an Oracle package directly from PHP using OCI8: $sql = 'DESC my_package'; $stmt = oci_parse($conn, $sql); oci_execute($stmt); this returns: Warning: oci_execute() [function.oci-execute]: ORA-00900: invalid SQL statement in /oci8_test.php on line 16 I know the command works as I tried it in SQLPlus.

Error Connecting To Oracle DB When Executed Within SQL Job social.msdn.microsoft.com

� Hi, � I have installed MS SQL Server 2005 and Service Pack 2�on a new�Windows 32-bit environment.� I also installed the 32-bit 10g client (the Administrator option).� The tnsnames.ora file is configured properly and I can tnsping to the Oracle database without any issues.� I have created a package in Visual Studio and it runs successfully when I execute the job manually.� I saved the package to the MS SQL Server and when I log into Management Studio to create a job for this package, I receive the following error: � Message Executed as user: xxxSYSTEM. ...rsion 9.00.3042.00 for 32-bit� Copyright (C) Microsoft Corp 1984-2005. All rights reserved.��� Started:� 10:42:37 AM� Error: 2007-10-10 10:42:37.28���� Code: 0xC0202009���� Source: x Connection manager "x.x"���� Description: SSIS Error Code DTS_E_OLEDBERROR.� An OLE DB error has occurred. Error code: 0x80004005.� An OLE DB record is available.� Source: "Microsoft OLE DB Provider for Oracle"� Hresult: 0x80004005� Description: "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.��� Provider is unable to function until these components are installed.".� End Error� Error: 2007-10-10 10:42:37.28���� Code: 0xC020801C���� Source: Data Flow Task OLE DB Source [18]���� Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.� The AcquireConnection method ca...� The package execution fa...� The step failed. I have created the package and logged into the server with the same ID to set up the job.� And I have set the ProtectionLevel property to "Don't Save Sensitive Data" since I know this has been an issue in the past when I tried automating the job.�

Running An SSIS Package After Using Import/Export Wizard social.msdn.microsoft.com

Hello All, I am a newbe at MS SQL 2005, so if this has already been answered elsewhere, please just point me in the right direction. I have successfully used the Import/Export wizard in "execute immediate" mode to import a table from Oracle 10g to MS SQL 2005. Works like a charm, but when I take the saved pacakge (saved as a� *.dtsx server side file)� - with no changes to the package and execute it from the either the "dos" prompt or from Windows explorer it fails at the login to Oracle step.� Yet when I check the package's "Connection Managers" source connection, all the settings, user-ids and passwords look fine.� The package does indeed execute, but I receive an ORA-01017:invalid username/password within the trace file of the package, but nothing has been changed from the Import/Export wizard which ran beatifully, thus verifying the appropriate acccess rights to Oracle. Any advice would be greatly appreciated. Doug

Databases :: Oracle.DataAccess.Client.OracleException: ORA-03113:end-of-file On Communication Channel forums.asp.net

ORA-03113: end-of-file on communication channel Exception details: Oracle.DataAccess.Client.OracleException: ORA-03113:end-of-file on communication channel My database is Oracle 10g, I am using .NET Framework 3.5 with Visual Studio 2008. It happened only once when first time in the morning I open my URL in my test server then this error popup at very first page of my site.

Adodb Doesn't Connect To Oracle? stackoverflow.com

i have installed WAMP server when trying to connect to Oracle it gives this error ORA-12541: TNS:no listener

Sql - Strings Don't Like Mutiple Variable Insertions? stackoverflow.com

I'm using php 5.2 with oracle 11.1.This code: $query = oci_parse($conn, "SELECT * FROM COMMENTS WHERE PINID=$pinID and COMMENTID=$commentID"); results in this error:<b>Warning</b>: oci_execute() [<a href='function.oci-execute'>function.oci-execute</a>]: ORA-00904: &quot;COMMENTS&quot;: invalid identifier in <b>C:IODwwwhello.php</b> on line <b>159</b><br /> [code]....

Databases :: Use Oledb Connection Class To Connect Oracle? forums.asp.net

I am using oledb connection class to connect oracle database, i provided username,password and provider,but it's showing this error ERROR [08001] [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). my connection string is Provider=MSDAORA;user id=scott;pwd=tiger;data source=tnsentry;

Calling Store Procedure In Oracle With ADO www.codeguru.com

I want to get a recoreset from SP in oracle.the code of store precedure is listed as below: --------------------------------------------- CREATE OR REPLACE PROCEDURE SP_TEST ( ret_cur out DEFPKG.EMPTY_CUR ) IS BEGIN OPEN RET_CUR FOR Select * FROM mytable; END SP_TEST; ------------------------------------------------- the type "DEFPKG.EMPTY_CUR" is defined in package "DEFPKG" TYPE EMPTY_CUR IS REF CURSOR; And the calling codes is: --------------------------------------------------------- ..... QSQL = "{call SP_TEST({resultset 1000,ret_cur})}" Set CPw = New ADODB.Command With CPw Set .ActiveConnection = Cn .CommandText = QSQL .CommandType = adCmdText End With Set Rs = New ADODB.Recordset With Rs .CursorType = adOpenStatic .LockType = adLockReadOnly End With Rs = CPw.Execute 'Error occurs -------------------------------------- when running to the last line,system report ORA-01060 error. (array binds or executes not allowed). Oracle document tell me that this is because "The client application attempted to bind an array of cursors or attempted to repeatedly execute against a PL/SQL block with a bind variable of type cursor". But I donn't know how to solve it. Thanks a lot.

SSIS Error While Pulling Data From Oracle Server social.msdn.microsoft.com

� Hi, � I have SSIS package which is created to pull data from oracle server. The package is running fine when executing from BI studio. But failing when i execute as a job. I am getting teh below error message. � Microsoft OLE DB Provider for Oracle"� Hresult: 0x80004005� Description: "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.��� Provider is unable to function until these components are installed.".� End Error� Error: 2007-10-15 16:04:15.60���� Code: 0xC020801C���� Source: Data Flow Task O...� The package execution fa...� The step failed. � � Appreciate if somebody can provide some inputs on this� . � �

Importing Data From Oracle 10g To Sql Server 2005 Using Linked Server social.msdn.microsoft.com

Hi, � I am using Windows 2003 server and Sqlserver 2005 by the use of Linked server , I made a connection to Oracle 10g after that I am importing records from Oracle to sqlserver 2005. When I made tnsnames.ora in sql machine , it worked fine but when i am�using tnsnames file from oracle server then i fiired importing procedure it returns below maintain error : � OLE DB provider "MSDAORA" for linked server "BI_ORACLE_LS" returned message "Unspecified error". OLE DB provider "MSDAORA" for linked server "BI_ORACLE_LS" returned message "Oracle error occurred, but error message could not be retrieved from Oracle.". Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "MSDAORA" for linked server "BI_ORACLE_LS". The provider supports the interface, but returns a failure code when it is used. � Please let me know. � Thanks �

Oracle Update www.vbcity.com

Hello Everyone,I have a problem with a vb application. When I run the application on a win95 or win nt 4 or win 98 PC it works perfectly.However when I run it on a win2000 PC I am getting the following error -2147217865 [Oracle][ODBC][Ora]ORA-00942: table or view does not existI am trying to add data to an Oracle table. I am using the Oracle ODBC driver and Oracle Client 8.1.7Can anybody please help me.RegardsPat Nolan

DataSource Controls :: SSIS Package Not Reading Configuration forums.asp.net

The short story is, I'm developing an SSIS package to select from a remote Oracle database (read: no Windows Authentication) and store into an SQL Server db. I can execute the package just fine in development and after importing, but when I run it as a scheduled job, I get an ora-01017 error (bad un/pw). The details are, I built this package and tested in in BIDS but came across the problem that BIDS really doesn't save the password I'd set for the Oracle connection. After poking around a bit, I found this [URL] which showed how to create an XML configuration which the package could then read. Fiddled around with that, got it working in BIDS. Connected to Integration Services on the server on which I want to run the package, imported it, right-clicked and did the "Run Package" option as a test, it works great. However, when I connect to the same server's Database Engine to create and schedule a job, I cannot connect to Oracle. For some reason, it seems as if the package is not reading the configuration when run in schedule. I've tried removing the job and re-working it, thinking maybe it didn't pick up the new version when I re-imported the package. A new job had the same problem. Next, I tried re-naming the .dtsConfig and doing the "Run Package" option as a test. Failed with the same error. A bit surprised, I thought I'd get some kind of file error and we wouldn't get as far as trying to talk to Oracle. Anyway, thinking maybe it's permissions on the configuration, fixed the .dtsConfig name and gave full access to Everyone. That ought to let the Agent see it. Scheduled up the job, still can't talk to Oracle. So it seems as if the scheduled version is ignoring the configuration. Anyone have any idea what I'm missing, that scheduling an SSIS package makes it act differently than running it manually? BTW, the instance under which we're running the package is VS 2005. BIDS 2005 to build the package.

Databases :: Visual Studio 2008 - Ora-04030 Out Of Process Memory? forums.asp.net

In Visual Studio 2008 if I setup a SQLDataSource to query an Oracle 8i table it returns data normally. However, if I try and setup a view from the same connection it locks up and eventually kicks out this error message: There was an error executing the query. check the syntax of the command and if present, the types and value of the parameters and ensure they are correct. ora-04030 out of process memory when trying to allocate 8 bytes (callheap, temporary memory) I can execute a query to the view usig Query Manager inside the Data Source Wizard, but when I go to complete the wizard it locks up and eventually kicks out that error. Why would I be able to query the view through query builder, but not fully setup the SQLDataSource? Using the .NET Framework data provider for Oracle. I'm not passing any parameters. The PC running VS has Oracle client 9 installed. I can connect to the DB using ODBC, but the Oracle .NET options (OLE DB, Oracle) fail.

Query Engine Error social.msdn.microsoft.com

I need help in this error.. � My procedure is executing fine in Oracle. when i try to add that procedure to crystal report it telling error.. query engine error : ADO errorcode :0x, source : microsoft OLE DB provider for Oracle ora-00936 -missing expression; � Inside the procedure i used the Union statements.. whether this causing the problem � Kindly help me.. � thanks in advance..

Databases :: Converting From Oracle9i To 10G? forums.asp.net

i have an asp site working with oracle 9.2 with oracle data provider (oracle.dataaccess.dll) now i want to upgrade to oracle 10g i have oracle 10g installed ODAC installed i Have my database working on 10g and can connect thought SQLPlus but if i try to connect with my asp app it show as error ORA-12154: TNS:could not resolve service name what else do i need to do to connect to 10g from my app

Databases :: ORA-24338: Statement Handle Not Executed But Its Getting On All Over Internet? forums.asp.net

actuly my site is working fine but suddenly site is giving "ORA-24338: statement handle not executed" this error i'm try to resolve this error but i could not get proper solution my prblm is tht when i access my site on my PC using "www.xyz.in" at tht time i access my site with report properly but whn i access my site on out of company or any cyber cafe or other internet pc thn i could nt access my site properly tht site is give me error....... ORA-24338: statement handle not executed i'm use oracle10g & database connection in "system.data.oracleclient" & most imp thing i;m using site number of years

Deploy SSIS Package To Production Which Has A Connection To Oracle Databse social.msdn.microsoft.com

Hi There, In SSIS package development environment, �I was able to connect to an oracle database and pull data into my sql server database. I installed the client tools for oracle and I put an entry into the tnsnames.ora and I was able to connect.� But in production environment, if I deploy the package on sql server, I was wondering if I had to do the same job of downloading the oracle client tools onto my production machine --which creates a tnsnames.ora file to it default location and then edit it with tthe tns entry-- or is there a better way to do this--avoiding the download? Can somebody plzz help me ? Thanks.

Linked Server Error social.msdn.microsoft.com

Hello, SQL Server version is Enterprise Edition 8.00.2039 SP4 and one oracle database linked via Microsoft OLe DB provider for Oracle. Oracle db name: SCP. � One of the job inserts data to sql database from querying oracle database;� randomly fails with the error message below. ************************** INSERT INTO �mom_services ('SQL TABLE') SELECT�* FROM ��OPENQUERY(SCP,'SELECT SERIAL_NO_ FROM SCADMIN.DEVICEM1 WHERE CONTAINER=''MOM''') *************************** Server: Msg 7399, Level 16, State 1, Line 3 OLE DB provider 'MSDAORA' reported an error.� [OLE/DB provider returned message: Oracle error occurred, but error message could not be retrieved from Oracle.] OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005:�� ]. � What I have done; Oracle client uninstalled server restarted and oracle client installed . Linked server deleted and recreated but nothing changed. � � Any ideas ? Osman

URGENT!!! Inserting Time With Con.execute In Oracle www.vbcity.com

Hi there,I wanna to insert Date & Time in an Oracle table from VB, using a Insert Query.I had used these:############################ CODE #########################################Dim sqlOrcl as StringDim conOrcl As New ADODB.ConnectionconOrcl.Open "Provider = OraOLEDB.Oracle.1 ;Persist Security Info=False;User ID=test;password = test;Data Source=oracledb"sqlOrcl = "Insert into testDate values(to_date('" & VBA.CStr(VBA.Format(VBA.CStr(VBA.Now), "dd-MMM-yyyy HH:Nn:SS AMPM")) & "','dd-MON-yyyy HH:MI:SS AM'))"conOrcl.Execute sqlOrcl#############################################################################The above Query is working absolutely fine but I have to use the to_date() of Oracle environment. Is there any way to insert the Date & Time in Oracle via a query without writing to_date() function.When I use this-------------sqlOrcl = "Insert into testDate values( '" & VBA.CStr(VBA.Format(VBA.CStr(VBA.Now), "dd-MMM-yyyy HH:Nn:SS AMPM")) & "')"It gives error  ORA - 01858: a non-Numeric Character found where a numeric was expected.The above error was with OraOLEDB.Oracle.1While when I use MSDAOra.1 it gives the following error.    ORA - 01830: date format picture ends before converting entire input string.I am unable to understand whenever I do not specify the Time with in the Query there is no requirement for the to_date() and the query works absolutely fine.Please help!!!Thanking you in anticipation.RGDSAMIT 

Migrate A Django Project From Db To Oracle? stackoverflow.com

I have a Django1.1 project that works with a legacy MySQL db. I'm trying to migrate this project to Oracle (xe and 11g). We have two options for the migration: - Use SQL developer to create a migration sql script. - Use Django fixtures. The schema created with the sql script from sql developer doesn't match the schema created from syncdb. For example, Django expects TIMESTAMP columns while sql developer creates DATE columns. Using syncdb with Django fixtures could be great but when trying to load the MySQL fixtures into Oracle, after using syncdb, I'm getting: IntegrityError: ORA-00001: unique constraint (USER.SYS_C004253) violated How can I find what part create the integrity error? update: Following an advice in the django mailing list I've tried: dump everything while connected to MySQL: python manage.py dumpdata > fixture.json Created a new Oracle user with an empty schema and switch the db connection to Oracle (didn't do syncdb) loaddata to Oracle with: python manage.py loaddata fixture.json I don't get an error when using loaddata but when running the server and navigating to localhost:8000 I'm getting: ORA-00942: table or view does not exist

SQL Server 2005 64-bit &&amp; Oracle social.msdn.microsoft.com

� OK new Windows 2003 Enterprise 64-bit with MS SQL Server 2005 64-bit.. Now I am migrating the DTS packages from our olld Windows 2000 Standard�with MS SQL 2000 (all 32-bit).�I am not moving the packages to SSIS yet just want to move the legacy DTS jobs over... However whenever I try and connect to the Oracle DB I got ORA-12154: TNS:could not resolve the connect identifier specified. � I have the Oracle 10g 32-bit & Oracle 10g 64-bit clients installed and I can run SQL+Plus and do everything just fine.� It is just in MS SQL 2005 I can not.� Even in SSIS I get the ORA-12154 error.� I can create an ODBC and test it and it works just fine... Has anyone here ever fixed this?� Some say it is b/c of the ('s around x86 in program files and I have done their suggestion in making a ProgramFilesx86 directory and copy the visual stupid & sql directories there... still nothing.� I have one of my DBA's searching Oracle for any patches but thought I would ask and see. � Thanks, � Billy S.

Rror - Oci_execute() [function.oci-execute]: ORA-00911: Invalid Character In Login.php On Line 34 www.sitepoint.com

This is my first attempt at using oracle and i'm trying to do a simple query and am having a problem. This is my connect code: PHP Code: $dbconn�=�oci_connect('username',�'password',�'dbase1'); $query�=��"SELECT�*�FROM�Employee�WHERE�LOWER(Username)='"�.�$uname�.�"'�AND�Password=�'"�.�sha1($pword)�.�"';"; print�$query; $parsed�=��oci_parse($dbconn,�$query); [Code]... Warning: oci_execute() [function.oci-execute]: ORA-00911: invalid character in Login.php on line 34 Warning: oci_fetch_all() [function.oci-fetch-all]: ORA-24374: define not done before fetch or execute and fetch in Login.php on line 36 I'm assuming the second error is a result of the first error. In the first error it says there is an invalid error... but i'm not sure what character its talking about because everything looks good to me.

Cannot SELECT Oracle CLOB Datatypes With ADODB.connection www.xtremevbtalk.com

SELECT SQL Command for Oracle CLOB Datatype Columns returns the runtime error (80004005) Datatype is not supported. Connection with ORA is achieved with Microsoft ActiveX Data Objects 2.0 Library (msado20.tlb).For example the following sample code returns this error. 'Declare Connection Dim cConnection as ADODB.Connection 'Declare Recorset Dim xQuery as ADODB.Recordset 'Start Connection Set cConnection = New ADODB.Connection With cConnection 'Connection Settings .CursorLocation = adUseClient .Provider = "MSDAORA" .CommandTimeout = 500 'Create connection with Oracle Database .Open "Data Source=<Host string>;User Id=" _ & "<User Name>;Password=<password>;", _ "<User Name>", "<password>", adConnectAsync End With 'Create Recordset Set xQuery = New ADODB.Recordset With xQuery 'Send SQL command to Oracle Database .Open "SELECT <ANY NON CLOB FIELD> FROM " _ & "<TABLE>",cConnection 'SQL query executed succesfully. .Open "SELECT <CLOB FIELD> FROM <TABLE>",cConnection 'Visual Basic Returns Error 80004005 End WithCould anyone help me please

Connect To Oracle Database Failing social.msdn.microsoft.com

I've worked with PL/SQL in the past, but am new to SQL 2005 and SSIS packages. I'm trying to read an Oracle table and insert rows into SQL 2005.I have entered my command in the OLE DB Source editor and click preview, and everything works fine. When I try to execute the Data flow, I keep getting an OLE DB connection error. � The error message I'm receiving is: ora-01017: invalid username/password; logon denied I've tried editing the connection string associated to my entry for the Oracle server, but everytime I add 'pwd=xxx', SQL 2005 removes it. I've also tried to edit the connection for the database thru connection manager, but it does not want to save the password I provide. Thanks for your help, Curt

Unable To Extend Temp Segment By 64 In Tablespace TEMP (SSIS Error While Copying Data From Oracle) social.msdn.microsoft.com

I am transferring data from oracle and getting below error message. � I using 4 data flow tasks with in a single control flow and all the 4 tasks quueries same table but populates data in to different sql tables based on the where contidion � �[OLE DB Source 1 [853]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.� Source: "Microsoft OLE DB Provider for Oracle"� Hresult: 0x80004005� Description: "ORA-01652: unable to extend temp segment by 64 in tablespace TEMP ".

Oracle Query Input Parameter Question social.msdn.microsoft.com

I am using reporting services in VS 2005 to create a report, database is Oracle 9i . I know I can't use MSSQL query syntax to query in my case, so how to write a Oracle query that accept a input parameter AND work at VS 2005 .rdl report? the MSSQL version of the query I want is: Select * from TableA inner join TableB On TableB.id = TableA.id Where TableA.name = @BPARAM1 but because i am connecting with a Oracle database, @BARAM1 will not work. After VS 2005 pop out a parameter dialog and ask for @BARAM1 value, it will give out ORA-00936 error because Oracle use : instand of @. So I change my query to: Oracle version: Select * from TableA inner join TableB On TableB.id = TableA.id Where TableA.name = :BARAM1 Here is the problem, it throw me another error ORA-00936 , I believe it mean :BARAM1 has not assign any value yet? Someone can help me rewrite my query would be most appreciate. Thanks

How To Create A Setup File For The Project visualbasic.ittoolbox.com

Dear AllI have created a project which is working fine on my computer (desk top).The programme has from end as VB-6 and Database is in Oracle 9i. The EXEfile created in my comuter alos works fine on my desktopI now want to create a setup file so that I can transfer the programme tothe user without installing the vb in his computerI have third party components from FAR POINT and SHERIDIAN used in myprogramme. I think when i create a successful Setup.exe I dont have toinstall the third party components in my user's PC also---am i right?The user has Ora 9i installed in the computer - but I dont find ORACLE ODBCDriver in the Settings---->>>Oracle ODBC listed there but I find Oracle inORA Home.When i use the old setup file created with oracle 8i - The error that i getisRun-time error - '2147467259(80004005)';[Microsoft][ODBC driver for Oracle][Oracle] ORA - 12154TNS Could not resolve service name'Any help or guidance will be most appericiated'Turab

Apache Not Loading Oracle Dll stackoverflow.com

on win 64, I installed apache, php etc. Everything works fine, except the oracle part. I can connect to oracle from sql developer which means my tnsnames.ora file is correct. When apache starts, there are no errors in the logs. But when I try to connect to oracle from my database, oracle module php_oci8.dll is not loaded. What am I doing wrong?

Package Doesn't Run Anymore On SP2 social.msdn.microsoft.com

Hi all, I've installed SP2 on my server.�If I run the package on the server, the package worked there�before the installation of SP2. Now with SP2 it doesn't work anymore. In VS2005 on my computer the package works before and after the installation of SP2. He gives an error with the execution of a sql-task on an oracle server: Error :Executing the query "insert into cube_content values (trim(?), trim(?), trim(?), trim(?), trim(?), sysdate) failed with� the following error: "ORA-01401: inserted value too large for column". Possible failure reasons: Problems with the query, "ResultSet property not set correctly, parameters not set correctly, or connection not established correctly. Anybody an idea? � Thanks, Dennis � � �

Oracle Service Names www.codeguru.com

How to get oracle all the service names from Oracle file tnsnames.ora by using visual basic 6.0?Thanks in advance

Problem Executing A Oracle Procedure Using Execute Sql Task social.msdn.microsoft.com

Hi All, I am trying to execute a Oracle Procedure through Execute Sql Task but it keeps throwing back an error ORA:00900. Is it possible to execute the procedure from this object?�Do I need to use the script task to execute this. If yes then how? Any help would be appreciated. Thanks in advance. Amol � � �

Connecting SQL Server With Oracle Forms 9i/10g www.dbforums.com

Could anyone please guide me in detail to connect Oracle Forms 9i/10g with MS SQL Server database? To connect with Oracle Database, we need to copy and paste the tnsnames.ora file from the Oracle Database folder to the Oracle Forms folder. But how do i connect with other databases like SQL Server, MS Access, and so on? Thanks in advance.

Connecting SQL Server With Oracle Forms 9i/10g forums.databasejournal.com

Could anyone please guide me in detail to connect Oracle Forms 9i/10g with MS SQL Server database? To connect with Oracle Database, we need to copy and paste the tnsnames.ora file from the Oracle Database folder to the Oracle Forms folder. But how do i connect with other databases like SQL Server, MS Access, and so on? Thanks in advance.

Oracle Connection Error www.xtremevbtalk.com

I was recently told that if you use the Microsoft OLE DB Provider for Oracle that you don't have to install the client. Well, I tried to switch from the Oracle provider for Oracle to the Microsoft Provider from Oracle, uninstall the Oracle client, but it gives me the following error: "Error while trying to retrieve text for error ORA-12538". Does anyone know how to resolve this? Thanks in advance!

Databases :: Maximum Processes Exceeded In Oracle - Server Error - ORA 00020 forums.asp.net

i have developed a student database as a sample in oracle 9i database. i am using VS2005 with production server IIS5 in windows xp and oracle on the same system. when i was executing record search the aspnet_wp.exe create a active session in oracle. one again i repeat the search with some other data the oracle server returns error ORA-00020: maximum number of processes (%s) exceeded. default processes in oracle is 100. the problem is the inactive processes will not be cleared. whenever i hit the database a new process was created with the help of aspnet_wp.exe and use the default_consumer_group. is any solution to clear the inactive processes through the code. I am using vb.net with data access class system.data.oracleclient. the same problem is happened with oracle.dataacesse.oracleclient.(ODP.NET)

Why Can't T-SQL Access Oracle DB When VB6 Can? www.sqlteam.com

Hi all, SQL Server 2005 SP2 Windows XP Pro SP2 Oracle 10g Client 10.2 Oracle Data Access Components 10.2 VB6 Oracle Rdb 7.1 (not Oracle RDBMS). I trying to access a remote Oracle Rdb database via a linked server in SQL Server 2005 management studio but having no luck. The remote database is accessed via an Oracle alias in TNSNAMES.ORA called my_oledb (see below) and I know it works ok becuase I'm able to access the remote database via VB6 (ADODB) using a very simple app whose connection string looks like this... con.ConnectionString = "Provider=OraOLEDB.Oracle.1;User ID=someusername; Password=topsecret;Data Source=my_oledb" I got this example VB appication off the net but have to admit I'm not sure of the difference between OraOLEDB.Oracle.1 & OraOLEDB.Oracle. The alias in TNSNAMES looks like this... my_oledb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = spike) (Port = 1527)) ) (CONNECT_DATA = (SERVICE_NAME = oci_oledb) ) ) I can also TNSPING this alias without any probems. My SQL server linked server is setup as follows. exec sp_addlinkedserver @server = 'MFP2', @srvproduct='Oracle', @provider = 'OraOLEDB.Oracle.1', @datasrc = 'my_oledb' exec sp_addlinkedsrvlogin @rmtsrvname='MFP2', @useself='false', @locallogin='sa', @rmtuser='******', @rmtpassword='******' Using both openquery and four part naming (?) I get the following errors select job_title from mfp2...jobs OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". There are no schemas in the Oracle database so I've just used three dots between the linked server and the table name. Again I know this syntax works becuase I have used it sucessfully with ODBC drivers. select * from openquery(mfp2,'select * from jobs') OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". The passwrods are correct on the Oracle database as these are the ones used in the VB6 application. Trying to expand the catalogue also causes management studio to hang. Anyone spot the obvious mistake? I did read on the net a while ago that registry entries might be rquired on the PC/server, is this still necessary? Thanks in advance Dave

Service Termination www.dbforums.com

Hi,, application sql server is connecting to oracle8 DB. when bringing the oracle DB down for backup one service of application server is terminated and getting the following error as showsin Event viewer"Oracle error message code 1041 op 0, ORA-01041: internal error. hostdef extension doesn't exist" Any suggestion for this problem. Thanxs

Linked Server (Oracle 9i) bytes.com

Hello all, Having problems connecting to an Oracle 9i database from within SQL/Server 2000 using the Security/Linked Servers feature. Server1 (SQL/Server) ----------- Windows Server 2003, Standard edition MS SQL/Server 2000 Oracle 9i Client kit (OLEDB & ODBC) & Enterprise management tools Microsoft ODBC for Oracle Oracle OLEDB MDAC 2.8 RTM Server2 (Oracle) ----------- Windows 2000 - Advanced Server Oracle 9i database (v9.2.0.1.0) Two nodes clustered using Microsoft cluster manager. (Nodes are DATABASE01 & DATABASE02 - Cluster is WMCLUSTER) When I try to connect to the linked server in Enterprise Manager I get the following error messages. Error 7399 OLE DB provider 'MSDAORA' reported an error. Authentication failed. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.]. From within Query analyzer I get a slightly different message reporting that the username/password are incorrect. dbcc traceon(7399) select * from TURLIVE..SONICA.INV_LOC Server: Msg 7399, Level 16, State 1, Line 3 OLE DB provider 'MSDAORA' reported an error. Authentication failed. [OLE/DB provider returned message: ORA-01017: invalid username/password; logon denied ] OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.]. I know the username/password combination is correct and I can use these from with Oracle enterprise Manager with sucess. TURLIVE is the name I've given the linked server, SONICA is the name of the schema on the Oracle database and INV_LOC is a valid table. TURLIVE is also the name of the database instance on Server2. Steps taken so far Install Oracle client tools (Enterprise Manager, Net manager etc) on Server1. Setup an entry in TNSNAMES.ORA to the cluster that has the Oracle database. e.g. TURLIVE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = WMCLUSTER)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = TURLIVE) ) ) This works fine, I can connect via Oracle Enterprise manager and I can TNSPING WMCLUSTER, DATABASE01 & DATABASE02. Configured an ODBC source to TURLIVE. On Server1 I've configured the linked server using the following SQL. sp_addlinkedserver 'TURLIVE', 'Oracle', 'MSDAORA', 'TURLIVE' sp_addlinkedsrvlogin 'TURLIVE', false, 'sa', 'sonica','******' (password blanked) I then rebooted Server1 The properties of the new linked server are: Product name = Oracle Data Source = TURLIVE Provider String = blank I've modifed the registry on Server1 as instructed by a Microsoft KB article. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCMTxOCI OracleXaLib = "oracleclient8.dll" OracleSqlLib = "orasql8.dll" OracleOciLib = "oci.dll" Still no luck. Can anyone please point out he bleeding obvious? :-) Thanks in advance As an aside, has anyone ever configured a linked server to an Oracle Rdb (Previously DEC Rdb running on OpenVMS and DEC UNIX) database? Are there any HOWTO guides for this type of connectivity? Cheers Dave.

Unreadable Charactors-Oracle To SQL Server 2005 Database social.msdn.microsoft.com

Hi everybody: I have some trouble in Oracle Database client and SQL Server 2005,when I SELECT some table(in that table have some japanese charactors and these table are in SQL Server 2005 ) in Oracle Database client.And I have some errors as follows: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC]DRV_GetRows: preceding 2 lines from MSQL3 CauseAnd the detail description are as following: 1. Table A in SQL Server 2005 has datatype as nchar. Data stored in this table are Japanese charactors, for eg カラー, �?番, etc and some are English charactors. 2. ODBC version 2000.81.9002.00 is set in Oracle Server. 3. a) Connection to SQL Server 2005 (as mentioned in Point 1) is done through a database link object, named MSQL on Oracle 10G. b) NLS_CHARACTERSET in 10G is UTF8. c) NLS_NCHAR_CHARACTERSET in 10G is AL16UTF16 4. We use PL/SQL DEVELOPER 7.0 and client's unicode is set as UTF8. Problem: Sometimes We keep on getting unreadable charactors (ie ?????) when we use PL/SQL to run queries from Table A.But other sometimes we have the error as abovei.e ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC]DRV_GetRows: preceding 2 lines from MSQL3 Cause � However, no problem found so far for English charactors. � Thank you very much.

Importing From Oracle 10g bytes.com

I am trying to import 6M records in a table from an Oracle 10g database into a SQL Server 2000 database. After importing 1.5M+ records I get the following error: Ora-01555: snapshot too old: rollback segment number 129 with name "_SYSSMU129$" too small How can I speed up the import process between Oracle and SQL Server? The database box I'm using has 12GB of memory and 1.5 TB of space. It shouldn't be a hardward problem. :-) Thanks in advance.

Error Opening Crystal Report With Oracle Database www.xtremevbtalk.com

I use Crystal Reports 8.5, Visual Basic 6 and I have an Oracle Database.I want to open a Crystal Report from VB6, but what seemed to be very simple with MySQL and Access, now seems very complicated with Oracle.This is the code I tried, but I get the Error ORA=00933:SQL command not properly ended.Can anyone help me PLEASE !*******************************Dim RepName As StringDim crxApp As New CRAXDRT.ApplicationDim crxRep As New CRAXDRT.ReportDim i As Integer repstring = Me.Command2(Index).Caption Set crxRep = crxApp.OpenReport("R:" & repstring) crxRep.DiscardSavedData For i = 1 To crxRep.Database.Tables.Count crxRep.Database.Tables(i).SetLogOnInfo "", "", "usrname", "passwd" Next i Me.CRViewer1.ReportSource = crxRep Me.CRViewer1.ViewReport

Getting ORA Oracle Error Code Using Function Oci_connect? stackoverflow.com

The PHP function oci_connect (which connects to an Oracle database) just returns false if it fails, which at the moment I handle like this: $connection = oci_connect($username, $password, $database); if (!$connection){ return $result = "Trouble connecting to the Oracle Database"; } But really I'd like to have the actual ORA error code, so I can be more informative.

Problem With Oracle Selecting Object Types bytes.com

I have the following object type created in Oracle (OCI8): create or replace type address as object ( address VARCHAR2(80), city VARCHAR2(80), state VARCHAR2(20), zip VARCHAR2(10) ) and I have the following table created: create table test ( address ADDRESS ) and when I run this: $sql = "SELECT * FROM test"; $s = ociparse(O_CON, $sql); ociexecute($s); I get this error: Warning: ociexecute(): OCIDefineByPos: ORA-00932: inconsistent datatypes in /home/httpd/html/stats/test.php on line (the ociexecute line) Can I not select custom types from Oracle or is there something else I have to do?

ADO Through VB To Connect Oracle Database www.vbcity.com

hi all,i am facing a specific problem.i have written a program in VB6 , using ADO and DBGRID for database connectivity in oracle. I have oracle 8 and VB installed on PC having Windows NT Server 4 as Operating system.         It works fine when run on this PC. There are some other PCs on LAN which are having Windows NT workstation as operating system, but none of VB, Oracle is installed on them.What i want to do is to develop a package on Windows NT server 4 PC. and install the project on other PCs on LAN so that they can use the database on SERVER.i am facing following problems...1) while creating package following errors come      a) no dependencies found for MSADO20.TLB      b) MSSTDFMT.DLL file is out of date2) when i run package developed by using PDW i get following message while running the programs on PCs on LAN   " Oracle client and networking components were not found. these components are supplied by oracle corporation and are part of oracle 7.3.3 or higher client software installation. you will not be able to use this provider untill these components are installed."if i install the client part of oracle on these PCs then following error comes"Run time error 2147467259 (80004005)ora-12154: TNS: could not resolve service name" where is the problem.what i want to do is to1) develop a package for the code.2) install it through setup files on all the computers on LAN ( i don't want to install oracle and VB on these PCs)3) run the program on these PCs on LAN to access oracle datbase placed on my server through this VB program.Please help me outBest regards,amit

Why Can't T-sql Access An Oracle Database When VB6 Can? social.msdn.microsoft.com

� Hi all, SQL Server 2005 SP2 Windows XP Pro SP2 Oracle 10g Client 10.2 Oracle Data Access Components 10.2 VB6 Oracle Rdb 7.1 (not Oracle RDBMS). � I trying to access a remote Oracle Rdb database via a linked server in SQL Server 2005�management studio but having no luck.��The remote database is accessed via an�Oracle alias in TNSNAMES.ORA called my_oledb (see below) and I know it works ok becuase �I'm able to access the remote database via VB6 (ADODB) using a very simple app whose connection string looks like this... � con.ConnectionString = "Provider=OraOLEDB.Oracle.1;User ID=someusername; Password=topsecret;Data Source=my_oledb" � I got this example VB appication off the net but have to admit I'm not sure of the difference between OraOLEDB.Oracle.1 & OraOLEDB.Oracle. � The alias in TNSNAMES looks like this... � my_oledb = �(DESCRIPTION = ��(ADDRESS_LIST = ���(ADDRESS = (PROTOCOL = TCP) (Host = spike) (Port = 1527)) �) ��(CONNECT_DATA = (SERVICE_NAME = oci_oledb) �) ) � I can also TNSPING this alias without any probems. � My SQL server linked server is setup as follows. � exec sp_addlinkedserver @server = 'MFP2', @srvproduct='Oracle', @provider = 'OraOLEDB.Oracle.1', @datasrc = 'my_oledb' � � � exec sp_addlinkedsrvlogin @rmtsrvname='MFP2', @useself='false', @locallogin='sa', @rmtuser='******', @rmtpassword='******' � Using both openquery and four part naming (?) I get the following errors � � � select job_title from mfp2...jobs OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". � There are no schemas in the Oracle database so I've just used three dots between the linked server and the table name. Again I know this syntax works becuase I have used it sucessfully with ODBC drivers. � select * from openquery(mfp2,'select * from jobs') OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". � The passwrods are correct on the Oracle database as these are the ones used in the VB6 application. � Trying to expand the catalogue also causes management studio to hang. � Anyone spot the obvious mistake? � I did read on the net a while ago that registry entries might be rquired on the PC/server, is this still necessary? � Thanks in advance � Dave

Why Can't T-SQL Access Oracle DB When VB6 Can? social.msdn.microsoft.com

� Hi all, SQL Server 2005 SP2 Windows XP Pro SP2 Oracle 10g Client 10.2 Oracle Data Access Components 10.2 VB6 Oracle Rdb 7.1 (not Oracle RDBMS). � I trying to access a remote Oracle Rdb database via a linked server in SQL Server 2005�management studio but having no luck.��The remote database is accessed via an�Oracle alias in TNSNAMES.ORA called my_oledb (see below) and I know it works ok becuase �I'm able to access the remote database via VB6 (ADODB) using a very simple app whose connection string looks like this... � con.ConnectionString = "Provider=OraOLEDB.Oracle.1;User ID=someusername; Password=topsecret;Data Source=my_oledb" � I got this example VB appication off the net but have to admit I'm not sure of the difference between OraOLEDB.Oracle.1 & OraOLEDB.Oracle. � The alias in TNSNAMES looks like this... � my_oledb = �(DESCRIPTION = ��(ADDRESS_LIST = ���(ADDRESS = (PROTOCOL = TCP) (Host = spike) (Port = 1527)) �) ��(CONNECT_DATA = (SERVICE_NAME = oci_oledb) �) ) � I can also TNSPING this alias without any probems. � My SQL server linked server is setup as follows. � exec sp_addlinkedserver @server = 'MFP2', @srvproduct='Oracle', @provider = 'OraOLEDB.Oracle.1', @datasrc = 'my_oledb' � � � exec sp_addlinkedsrvlogin @rmtsrvname='MFP2', @useself='false', @locallogin='sa', @rmtuser='******', @rmtpassword='******' � Using both openquery and four part naming (?) I get the following errors � � � select job_title from mfp2...jobs OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". � There are no schemas in the Oracle database so I've just used three dots between the linked server and the table name. Again I know this syntax works becuase I have used it sucessfully with ODBC drivers. � select * from openquery(mfp2,'select * from jobs') OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". � The passwrods are correct on the Oracle database as these are the ones used in the VB6 application. � Trying to expand the catalogue also causes management studio to hang. � Anyone spot the obvious mistake? � I did read on the net a while ago that registry entries might be rquired on the PC/server, is this still necessary? � Thanks in advance � Dave � � � � � � � � � �

Ora-12645 Paramater Does Not Exist social.msdn.microsoft.com

I get the ora-12645 error when doing an import from oracle to mssql.� The error comes-up when setting up the datalink properties of the source database which is oracle.� This error happens on a 2003 server machine using the import/export wizard.� It works fine when using an xp machine. any ideas?

ORA-01704: String Literal Too Long When Updating A Record? stackoverflow.com

I am trying to update an Oracle Database record and i keep getting this error: ORA-01704: string literal too long 5 I looked up that error and it seems that i have a limit of 4000 charters since i am using Oracle 10g. However, the prgblem is that its the same exact data i am putting back into that record so that is why i am unsure as to why its giving me that error for the same amount of data i took out of it. Here is my update code: Dim myCommand As New OracleCommand() Dim ra As Integer Try [code]....

Oracle DB Connection Question + VBA www.xtremevbtalk.com

Is there a way to connect to an oracle databse through ADO when the client executing the vba code does not have a tnsnames.ora file on their machine. I have tried several different connection strings and all want the client to resolve the database location. I have even created a file dsn on a share drive, which points to the oracle database, used that in the connection string, and still the external client is receiving an error message that the oracle database cannot be found. Is this even possible or am I just wasting my time. Thanks for any and all help on this.

Databases :: ORA-12154: TNS: Could Not Resolve Service Name? forums.asp.net

I am facing a problem when the number of user to my web application increase,the application crashes and the error message displayed is: "ORA-12154: TNS: could not resolve service name".This happens only when the users are uploading attachments,for some user it work well,for others it throws this error. Additional information:Some code is generated using LLBLgen Pro tool.The Application is using Asp.net 2.0 frame work Database is oracle 10 g.

MS ODBC For Oracle - INSERT INTO www.xtremevbtalk.com

insertQuery = "INSERT INTO KS_PRIJSVRAAGVC ([WRFCODE],[WRFOMS],[WRFREGIO],[DATUM],[PVOMS],[PVNR],[CALC]) VALUES ('" & TextBox7.Text & "','" & TextBox9.Text & "','" & ComboBoxREG.Text & "','" & TextBox8.Text & "','" & TextBox6.Text & "','" & TextBox10.Text & "','" & ComboBoxINI.Text & "')"adoCmd.CommandText = insertQueryadoCmd.CommandType = adCmdTextadoCmd.ActiveConnection = dbadoCmd.ExecuteERROR ON LINE: adocmd.executeRun time error : 2147467259(80004005) [MS][ODBC for ORacle][Oracle]ORA-00928 missing keyword: SELECT______________________________Why doens't this work? an "UPDATE" does not give any error!or should I try with recordset.addnew... how?Curleone

ORA-12154: TNS:could Not Resolve The Connect Identifier Specified www.vbcity.com

Hi,I tested my TNS and I am connected. I have the latest Oracle Client 10 and ODP.Net 10I am getting the following error on connection:ORA-12154: TNS:could not resolve the connect identifier specifiedImports SystemImports System.DataImports Oracle.DataAccess.Client    Dim con As OracleConnection = New OracleConnection    con.ConnectionString = "User Id=user1;Password=password;Data Source=TNS_NAME_SERVICE_NAME;"    Try      con.Open()      MessageBox.Show("Connected")    Catch ex As Exception      Msg = ex.Message      MessageBox.Show(Msg)    End Try...Can someone point out how to resolve this error?Thanks in advance,

ODBC�call Failed - Version: 2002 (10.0) XP www.utteraccess.com

I have an Access 2002 database that links several tables from Oracle 9i. I am having all sorts of problms with Linking and accessing the Oracle tables within Access. There's no problem with my DSN, I've tested the connection outside of Access and it connected with no problem. Note: I use crystal report and I have no problem with the connection in Crystal. Here's one error message I get: ***************************************************************************�********* ODBC -call failed. [Oracle][ODBC]ORA-01017: invalid username/password; logon denied (#1017)[Microsoft][ODBC Driver Manger] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (#0) ***************************************************************************�********* I also get this error as well: ***************************************************************************�********* [Oracle][ODBC][Ora]ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist SVR4 Error: 2: No such file or directory (#1034)[Microsoft][ODBC Driver Manger] Driver�s SALSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manger] Direr�s SQLSetConnectAttr failed (#0) ***************************************************************************�********* I have tried this on another computer and I can access this database with no problems. When I try to recreate a new database and re-link these table it seems to work okay for several try and the error would pop-up again. I have tried various venues to get help for this but to no avail. Even my IT techs are out of solutions. I have even re-install Access on my machine but that didn't fix the problem either. I hope someone may have a fix for this problem here.