Windows :: Error When Running Macro Excel
Jan 13, 2012I installed Oracle 11gR2 database for windows 7. I believe it's 32 bit. I keep getting an error when I run my macro excel: Error while trying to retrieve text for error ORA-01019.
View 1 Replies
ADVERTISEMENT
Windows / .NET :: Excel VBA Macro To Fetch Data From Oracle Database
Aug 1, 2012we are using ERP System based on Oracle DB. I have an oracle client 10.2.0 installed on my machine (Win 7/64-Bit) and trying to create Excel(2010) VBA-Macro to get datas out of the Oracle DB using a SQL query:
On my old machine (Win XP/Excel 2007) following worked fine:
strConOracle = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=" & strHost & ")(PORT=1521))" & _
"(CONNECT_DATA=(SERVICE_NAME=" & strDatabase & "))); uid=" & strUser & " ;pwd=" & strPassword & ";"
Set oConOracle = CreateObject("ADODB.Connection")
Set oRsOracle = CreateObject("ADODB.Recordset")
oConOracle.Open strConOracle
Set oRsOracle = oConOracle.Execute(strSQL)
All the datas in the variables coming from cells or userforms - I am 100% sure all this is correct, as as said, it works on any Win XP Machine with Excel 2007
But trying same with Win 7/64-Bit/Excel 2010 gives me following error: MS ODBC Driver for Oracle: ora-01019: unable to allocate memory in the user side.
Forms :: Create Macro In Excel With OLE2
Apr 15, 2010URL.... I have one query.Aim of Program: Create Macro in Excel with OLE2 in ORACLE FORM.I mention below codingDeclare
application OLE2.OBJ_TYPE;
workbooks OLE2.OBJ_TYPE;
workbook OLE2.OBJ_TYPE;
worksheets OLE2.OBJ_TYPE;
worksheet OLE2.OBJ_TYPE;
WorkFont OLE2.OBJ_TYPE;
vbproject OLE2.OBJ_TYPE;
vbcomponents OLE2.OBJ_TYPE;
item OLE2.OBJ_TYPE;
codemodule OLE2.OBJ_TYPE;
args OLE2.LIST_TYPE;
[code]...
SQL & PL/SQL :: How To Append Data Into Macro-enabled Excel File
Aug 18, 2010My requirement is to export Oracle table's data into an already existing excel file with Macros (.xlsm) using a procedure. I am able to write/append the data into the simple .xls file. But I am searching whether any way of appending into .xlsm file. "how can we append the data into a Macro-enabled excel file?".
View 3 Replies View RelatedClient Tools :: Not Able To Make ORA Connection Through Macro In Excel
Mar 15, 2012i have windows 7 on machine. When i am trying to connect to oracle client using macros from excel like
OraSession = CreateObject("OracleInProcServer.XOraSession")
its giving me error saying "activex component cant create the object."
Windows :: Test If Database Is Running?
Sep 15, 2010I have a unix script that will check if the database is up and running. I need a similar script but this time in windows batch file.
this is the snippet of the code from the unix script:
#! /bin/sh
sqlplus -s /nolog > /dev/null 2>&1 <<EOF
whenever sqlerror exit failure
[Code].....
Forms :: Running Reports 6i On Windows 7?
Nov 2, 2009would like to check if anybody running Form/Report 6i on Windows 7 ? I meant not XP mode.
View 3 Replies View RelatedORA-12154 Running 32 Bit Oracle Software 0n 64 Bit Windows?
Oct 7, 2011There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.
Since all the 32 applications will have the path C:\Program Files (x86) on 64 bit windows, The PATH variable doesnt recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client.
Oracle Client: 10.2.0.3 32 bit
Windows OS: Windows server 2008 R2 64 bit
I have referred the below document from the metalink(which states that the bug is fixed in 10.2.0.3 client).
ORA-12154 or ORA-6413 Running 32-bit Oracle Software on 64-bit Windows OS [ID 334528.1]
Forms :: Running Oracle Database 10g On Windows 7
Nov 12, 2009I was install windows 7 on my computer,oracle database10g and forms 10g installed successfully. I Cannot run forms on the browsers , how i can run my programs
View 9 Replies View RelatedSee If PMON Or SMON Running On Windows Server?
Feb 27, 2013On windows server how can we see if the PMON or SMON is running? Is there a way, as we can see on linux using?
View 6 Replies View RelatedCons Of Running 8 Production Database Instance On One Windows Server
Dec 3, 2010We are planning to consolidate our Oracle Production DB into one server. We are basically a windows shop. Is it feasible to run 8 production Oracle DB in one windows server. All the DB are not really transaction intensive DB. 2 DB in the size of 300GB and others all DB falls under average size of 40GB.
I can take care of the HD slicing so Oracle does not enter into IO bottleneck. We are planning to go for external NAS or SAN for storage.
My main concern is on processor usage. The processor we are thinking about is Intel Xeon Quad Core x 2nos. Will there be a processor bottleneck or is there way in Oracle to assign processor usage(I belive there is no much tweaking options here)
Windows :: ORA-12154 - Running 32 Bit Oracle Software On Server 2008 64 Bit
Oct 6, 2011There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.
Since all the 32 applications will have the path C:Program Files (x86) on 64 bit windows, The PATH variable doesn't recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client. Still the user is facing the same issue.
Oracle Client: 10.2.0.3 32 bit
Windows OS: Windows server 2008 R2 64 bit
I have referred document [ID 334528.1] from the metalink(which states that the bug is fixed in 10.2.0.3 client).
How To Create Central Inventory For Oracle 11g Running On Windows Server
Dec 26, 2012--- Current Oracle Inventory pointing to the location of C:program FilesOracleInventory.
We are plannig to creat a central inventory for all Oralcle installations into to C:oraagentorainventory.
Forms :: Unable To Create Object For Excel 2007 / Windows 7?
Aug 11, 2010The below Oracle Forms code works fine for Excel 2003/Windows XP/IE6 but doesn't work for Excel 2007/Windows 7/IE8.
*********************
application := Client_OLE2.CREATE_OBJ('Excel.Application');
Client_OLE2.SET_PROPERTY(application,'Visible','TRUE');
workbooks := Client_OLE2.Get_Obj_Property(application, 'Workbooks');
args1 := Client_OLE2.create_arglist;
************************
There is no error while executing the form, by debugging we found that the control skips all the above code.
I'm using Oracle forms 10.1.2.3 and jre 1.6.0_16.
Windows / .NET :: Return String From Oracle Stored Procedure Using Excel 2003 VBA
Apr 12, 2013I am trying to return a value of an oracle stored procedure using Excel VBA.
OS: Win XP SP3
Excel 2003
Ora Client: 11g
By trying different things I have noticed, that I could have troubles with the ODBC-connection. Maybe I am not using the right one. To store data returned from select statements I have an ODBC-Connection (Driver: Oracle in XE), which works perfectly, e.g.:
'-----------------------
Sub Extract_Data()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim db_name, UserName, Password As String
cn.Open db_name, USerName, Password
[code]....
When debugging the connection string, I find the Provider=MSDASQL5.1.
ORA-01013 Error While Running Application
Jun 25, 2008I'm getting ORA-01013 Error while running the application. The queries are getting timed out.
Oracle version : 10g
OS : Unix platform and RAC.
And the aplication is connected using ODP.NET. Apart from increasing the timeout property, What are all the possible solutions to fix this issue, since this issue is becomeing very critical..It also affects the performance of the entire database also.
Forms :: Error 404 On Webpage When Running In 11g
Oct 27, 2011I am using oracle forms 11g
when i am running a forms the web page is giving error 404-not found.
ORA-01019 Getting Error When Running From AIX Client?
Feb 20, 2013getting this error when running from AIX client
database server is on 10.2.0.5.0
ORA-01019 is the error
PL/SQL :: Error While Running UTL_MAIL Package
Aug 8, 2012SQL> conn system/sys@ORCL;
Connected.
SQL> @F:oracleproduct10.2.0client_5RDBMSADMINutlmail.sql
Package created.
Synonym created.
SQL> @F:oracleproduct10.2.0client_5RDBMSADMINprvtmail.plb
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY UTL_MAIL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
319/5 PL/SQL: SQL Statement ignored
320/10 PL/SQL: ORA-00942: table or view does not exist
325/7 PL/SQL: SQL Statement ignored
326/12 PL/SQL: ORA-00942: table or view does not exist
PL/SQL :: EXCEL TEMPLATE Error Message?
Oct 31, 2013i have a xml sheet which contain 30 attributes,and only because of one attribute i got this error when i preview my xls sheet and the rest 29 attribute is working correctly.
Start Excel Previewonly open: falsemTemplate: C:Documents and Settingsesys36Local SettingsApplication DataOracleBIPublisherTemplateBuilderforExcel mp mp mp.xlsmTmpTemplate: C:Documents and Settingsesys36Local SettingsApplication DataOracleBIPublisherTemplateBuilderforExcel mp/tmp.xlsjava.lang.NumberFormatException: multiple points at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source) at java.lang.Double.valueOf(Unknown Source) at oracle.xdo.template.excel.render.BookDataWriter.copyCell(BookDataWriter.java:766) at
[code]....
SQL & PL/SQL :: ORA-00936 - Missing Expression Error While Running
Mar 28, 2013I am getting the ORA-00936: missing expression error while running the below stated query. Problem is that it is running and fetching the data successfully for the first 5 runs. But from the 6th run it is not fetching the data and throwing the ORA-00936: missing expression error. consider I am passing parameters to the query and for the first 5 values i pass its runnign fine. when i run the query for the 6th time or more with different parameter, its throwing the error. it does not seems to be the data issue because when i pass the 6th parameter for the first run on the next day, it is fetching data.
(SELECT ABC.POST_SMRY_CORR_I,NVL(ABC.CORR_TYPE_C,' ') AS CORR_TYPE_C,NVL(ABC.ENTR_DOC_I,' ') AS ENTR_DOC_I,
ABC.EST_LIQN_D, '' AS EVNT_TYPE_C, ABC.CORR_STAT_C
FROM POST_SMRY_CORR ABC,POST_ENTR_DISCP PSCWQ,ENTR_DOC ED
WHERE ABC.POST_SMRY_CORR_I = PSCWQ.POST_ENTR_DOC_I
and ED.ENTR_DOC_I = '123'AND ABC.ENTR_DOC_I=ED.ENTR_DOC_I
AND ED.ENTR_TYPE_C != 11
AND POST_ENTR_TYPE_C='PSC' AND DISCP_STAT_C !='CL' AND ABC.CORR_STAT_C !='CLS'
[code]....
Getting Error While Loading Excel File Into Oracle Database
Dec 30, 2010I am loading a Excel file into oracle database using a ORACLE form 6i and i am getting an ORA-302000. This Form run and load database file into database in many pc.
But One of the PC COuld not loading a Excel file into oracle database. Also i can't Create Excel file Database Through form 6i.
Forms :: Frm-41211 Integration Error / SSL Failure Running Another Product
Jan 20, 2010I have just migrated my database from oracle7 to Oracle9i. My application is still on forms 4.5 and reports 2.5.
i am having a problem after the migration. I am able to run my forms, but i cannot run my reports from my form (button). i am having the error : "frm-41211 integration error: SSL failure running another product". I want to mention that i am able to run the report from the report builder.
Forms :: Error While Running Report - File Not Dynamically Attached
Aug 1, 2013I am doing steps to run report in Forms....
when I running command rwserver server=reportserver10g in command prompt I am getting orapls10.dll file not dynamically attached error...
Forms and Reports and Database in my system only(practice purpose).
Forms :: Java.lang.ClassNotFoundException Error When Running A Form
Apr 18, 2006On a Windows 2003 64 bits server I have installed Oracle Application Server 10gR2 10.1.2.0.2 (Infrastructure + Business Intelligence and Forms option). I also upgraded to Portal 10.1.4. All components are up and running.
I wanted to test if Forms services are functional using the test form provided by OAS at installation (test.fmb/.fmx).
Steps executed:
1) Start -> Programs ->Oracle Application Server 10g -> Forms Services -> Run a form on the web for form=test.fmx
or in the IE browser:
2) [URL]
The applet is not starting and I receive the following error:
java.lang.ClassNotFoundException: oracle.forms.engine.Main
What does this mean? What should I do to make it work?
Forms :: Error While Running Oracle Look And Feel Template Form
Jan 5, 2012I am trying to setup oracle look and feel project on my local machine. For that i upgraded forms to 10.1.2.3 then i also applied path no 9593176 (But not yet performed steps related to jacob and webutil).
Problem : When i run Oracle look and feel template form it comes up with following error.
Forms Applet version is : 10.1.2.3
Exception in thread "thread applet-oracle.forms.engine.Main-1" java.lang.NoSuchMethodError: oracle.forms.handler.IHandler.getApplet()Ljava/applet/Applet;
at oracle.forms.fd.DrawLAF.init(DrawLAF.java:285)
at oracle.forms.handler.UICommon.instantiate(Unknown Source)
at oracle.forms.handler.UICommon.onCreate(Unknown Source)
at oracle.forms.handler.JavaContainer.onCreate(Unknown Source)
[code]..........
Client Tools :: Toad Error / Can't Continue Running Procedure
Jun 4, 2012I run procedure on toad 10.5, it gave me this error
Buffer overflow, limit of 20000 bytes
then it can not continue running the procedure.
Forms :: FRM-41211 / Integration Error / SSL Failure Running Another Product
Feb 5, 2013I have a form with a button for "Print Report " when I click button following error occurred :
FRM-41211 :integration error : SSL failure running another product
Forms :: Integration Error - SSL Failure Running Another Product With HP Deskjet D2680?
Sep 14, 2011"Integration error: SSL failure running another product" with HP Deskjet D2680.We are using 10gR2, Forms6i, and Report6i. The server is Windows 2003 Server, and the OS of the printer is XPIn one of our module, upon calling one report we always encounter Integration error: SSL failure running another product. Sometimes when we do not encounter it, the spooling takes too much time and it takes 6minutes just to print the first page of the report, succeeding pages takes 2-3minutes in interval.
At first we thought that the memory of the PC is the problem, but we tried to connect it to a 2gig RAM Win7 laptop, another laptop with 1gig RAM XP, and a 1g RAM Desktop. We tested 5 computers but the same problem occurs.
The problem is not encountered after we tried other HP Printer(HP 3940, 6988, & D4360). I just want to know the problem with the HP Deskjet D2680.
Reports & Discoverer :: Reports Not Running In Windows 7?
Jan 4, 2012We have Forms and Reports 6i which is perfectly running its reports in windows xp pc and even in windows 98 pc.
But recently we have installed windows 7 64 bit, but the reports not working here.