Ваш код работает на Forms 6i
при условии, что вы правильно прикрепили файлы .olb
и .pll
для webutil
, но для Oracle Fusion Middleware 11g
метод GET_FILE_NAME
следует заменить на CLIENT_GET_FILE_NAME
для поиска в вашей локальной файловой системе вместо сервера приложений, как показано ниже:
:block2.FILE_NAME := CLIENT_GET_FILE_NAME(File_Filter=> 'CSV Files (*.Csv)|*.Csv|');
идентификатор ‘client_get_file_name’ должен быть объявлен
— Ramiz Tariq
14.03.2019 06:50
@RamizTariq, вы уверены, что добавили webutil.pll
под узел Attached Libraries
и перетащили webutil.olb
в узел Object Groups
..? webutil.pll
имеет метод под названием client_get_file_name
.
— Barbaros Özhan
14.03.2019 08:17
Не прилагается. Есть ли другой способ прикрепить CSV-файл с помощью кнопки просмотра без использования webutil?
— Ramiz Tariq
14.03.2019 08:27
@RamizTariq Я не знаю и не думаю, что существует какой-либо другой способ, но я предлагаю вам добавить и использовать webutil.
— Barbaros Özhan
14.03.2019 08:47
Я прикрепил webutil.pll и webutil.olb. После прикрепления, когда я нажал кнопку, я получил сообщение об ошибке, когда триггер WHEN-BUTTON-PRESSED вызвал необработанное исключение
— Ramiz Tariq
14.03.2019 11:17
@RamizTariq, если вы вызываете форму с сервера приложений, вам нужно выбрать опцию Yes
при подключении webutil.pll всякий раз, когда появляется вопрос Remove path?
.
— Barbaros Özhan
14.03.2019 11:44
Я использую формы оракула на ноутбуке. При подключении webutil.pll я выбрал «Нет» для пути
— Ramiz Tariq
14.03.2019 11:50
@RamizTariq в любом случае вам нужен сервер приложений (webutil), даже если он находится на вашем локальном компьютере, вам нужно развернуть файл .fmb на этом сервере приложений, поскольку client_get_file_name
— это такая функция, которая используется путем вызова через веб-логику вместо клиента. -серверная логика.
— Barbaros Özhan
14.03.2019 11:59
Я настроил webutil по этой ссылке dbperfection.com/…. Теперь я получаю эту ошибку: внутренняя ошибка frm-40734 Ошибка pl/sql произошла после нажатия кнопки
— Ramiz Tariq
15.03.2019 07:26
@RamizTariq, пожалуйста, взгляните на этот связь, связанный с установка% CLASSPATH% и отсутствующие файлы jar
— Barbaros Özhan
15.03.2019 08:03
-
Hi all!
Queries:
1.I confronted this error in D2k forms v6i when one of the users ran his Application:
Error:Frm-40734:Internal Error:PL/SQL error occured.
Cause:A fatal Error in PL/SQL during Trigger execution.
Action:Notify DBA.
Level: > 25
After the execution of the above error,The Application Form closes on its own!!!
WHAT IS MEANT BY LEVEL > 25 IN THE ABOVE STATEMENT!
Why is this happening!
Looking for a speedy reply!
Regards,
Amitstora.
-
The level 25 is the system message level. The system assignes a number for all the messages. It is that number. You can suppress these message.
Thanks
saritha.
-
BTW .. I would suggest not to supress the level 25 messages as those are critical !! ensure it throws and handle it..
Vijay.s
-
Is it a Backend Problem!
Is this a Backend Problem.
As it says in the Oracle Docs Help that NOTIFY THE DBA!
How could we resolve such an error!
Regards,
Amitstora
-
Hi,
Just try debuging your application. Check out what all stuffs is being executed just before that FATAL ERROR. May be some stored procedure or database trigger is being executed and it may be refering some invalid objects.
Regrads,
Pinakin.
I have just started using Forms 11g after using 6i several years ago, so my memory is a bit foggy on where to find stuff. I’m not even sure what information you need in order to help me troubleshoot. I’m running on Windows 7 64-bit and the database is 11g.
I have two forms, both of which work in production, which makes me think the problem might be with my setup. One of the forms I can run locally without a problem, the other gives me this error message.
The main difference between the two forms is that the one that works uses text_io, the one that does not work uses client_text_io from the attached webutil library.
Can anyone tell me where to look for the root of this problem? I have looked through a bunch of folders under C:OracleMiddleware but cannot find any log files that seem to correlate with the problem I’m having.
Thank you!
Cali
Introduction
It was one of those days when things get delayed and you go past the deadline. Last week I faced a similar situation when an Oracle R12.1 (E-Business Suite 12.1) clone was not completed successfully.
Problem
All the cloning tasks were completed, however, during testing of the cloned instance, I discovered that Oracle Forms was having a problem.
- Launch any form ( For e.g Login as SYSADMIN=> System Administrator => Concurrent => Requests )
- The forms window opens, but it goes into an hour glass mode and after a few minutes it displays the following error message at the bottom of the form
FRM-40734:Internal Error:PL/SQL error occurred
Troubleshooting
I searched for the occurrence of the above error in all the logfiles in the $INST_TOP/logs/ora/10.1.3/opmn directory including the forms_default_group_1 subdirectory. But everything seemed normal in these logfiles with no reference to the above error code and message. I also performed a routine check of the $INST_TOP/logs/ora/10.1.3/j2ee/oacore directory, but no clue at all. This seemed to be one of those errors when the logfiles do not give much information for troubleshooting purposes.
Solution
Because of the several steps involved in the cloning process, I was under the impression that I could have done a mistake or missed a step or two. Hence I executed all the cloning steps again. But the issue refused to go away. I used the adadmin utility to run the ‘Compile APPS schema’, ‘Generate form files’, ‘Compile menu information’ and the ‘Compile flexfields’ programs. But the issue still refused to go away.
Finally, we ran the ‘Generate product JAR files’ adadmin program which helped fix the problem.
Conclusion
So you now know the trick when you face the same symptoms that I faced above !!
Forms 6i gives FRM-40734 Internal PL/SQL Error after Hourglass for 30 Min
Hi,
I am developing a New custom Form using a copy of Oracle Apps. TEMPLATE.FMB
(Out of two custom forms , I am getting the below issue in only one form and the other is working fine)
Everything works fine but I observed one unique issue during my testing.
I executed the form and entered a value in one column of the master record
(now the record in CHANGED status).
Now I pressed the F11 Key (for Enter-Query in Apps) for doing the
Query by ignoring the entered record values.
Instead of giving a message «Do you want to Save the changes you have made (or)
A Required Field must be entered»
But the Form shows the Hourglass(Busy) for 30 Minutes then gives the error :
FRM-40734 Internal PL/SQL Error
May I know in the above situation, what are the triggers the form will fire and in which sequence (forms 6i)
In summary what form triggers will be fired :
When a NEW record status is CHANGED and when the user invokes Enter-Query
(F11 on Apps and F8 on standalone) , before form changes to Enter-Query mode.
Any pointers to my issue resolution.
Below is my form canvas/block layout and I am getting the issue Only in Master Block and not in any of the detail blocks
MASTER BLOCK
DETAIL1 BLOCK
DETAIL2 BLOCK DETAIL2 BLOCK DETAIL2 BLOCK
thanks,
Shashi
Issue got resolved:
==================
In my case, The solution I found is renaming the Relations with a unique name.
When the Relation is created for two different master blocks
the «Block creation wizard» has given the same name for both
these relations.
I renamed both of them with a custom unique name then the issue got resolved now the form is behaving correctly.
thanks,
Shashi
FRM-40734: internal error: pl/sql error occurred
I am getting this error [FRM-40734: internal error: pl/sql error occurred] while running a form (FMX) developed in Forms 6i. The form is running on machines having Win XP, Win 2k, and Win 98. But not running on the same operating system of the other machines.
* I have completely uninstalled Developer 2000 both Forms 6i and Report 6i, and installed again.
* The «Start in» Path and «Bin» path for the application is also correct.
If anybody have idea kindly reply me quickly.
[email protected]
just some remote ideas :
any PLLs involved ?
any changes done on PLLs ?
FRM-40734:Internal Error:PL/SQL error occurred in Adjustment to invoice
Hello All
I have problem in AR Trasactions >> Transactions >>Query the invoice >>Actions >> Adjust FRM-40734:Internal Error:PL/SQL error occurred.
EBS R 12.1.2
SO. Enterprise Linux Enterprise Linux AS release 4 (October Update 7)
Last night was generated forms with utility adadmin.
I hope you can help me my enviorment is PROD
Regards
Last night was generated forms with utility adadmin.Was the form generated successfully?
Have you applied any patches recently?
If you have any other identical instance (same patchset), rename the form you have in production instance and replace it with the one from the other instance and see if you can reproduce the issue.
Could you please confirm that you have no invalid objects in the database?
I hope you can help me my enviorment is PRODPlease log a SR for production issues.
You may also obtain the FRD file to get more details about the error.
Steps To Take FRD Trace in 11.5.10 & R12 [ID 867943.1]
R12: Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications [ID 438652.1]
Thanks,
Hussein
FRM-47026 Cannot get parameter error when using bi graph
Hi,
I have recently tried to use the BI Graph bean provided as a demo from Oracle.
I have amended the cursors and put into our system but get an error on the master graph.
When i mouse click on a column i recieve the error from forms :
FRM-47026 Cannot get parameter GRAPH_INFO attributes from parameter List CUSTOM_ITEM_LST19: no such names parameter exists.
Any ideas. i have not changed the code in this trigger only the procedure cursors to work within our system
code in trigger:
eventValues := get_parameter_list(:system.custom_item_event_parameters);
get_parameter_attr(eventValues,’GRAPH_INFO’,eventValueType, tempString);
set_custom_property(‘PJC.WAREHOUSEGRAPH’,1,’HIDE_GRAPH’,»);
FORMSGRAPHSAMPLE.clearData(‘PJC.DETAILGRAPH’);
FORMSGRAPHSAMPLE.populateDetailGraphData(‘PJC.DETAILGRAPH’,tempString,’,’);
thanks
Hi,
Did you ever get this issue resolved?
I am facing the same problem.
Thanks
Ian
SQL error when using JDBC
I am trying to use JDBC to perform an update on a single row, but I keep getting the following exception:
java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java, Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java, Compiled Code)
at …
I cannot find any flaws in the sql-string I am trying to execute, and the exact same string works fine in SQL+. Can anyone please explain this?
I am using Oracle8.04 and the ‘jdbc80520-nt’ driver.
Can u post your sql Query.
FRM-40734 . Internal Error — Unable to resolve
Hi All,
I am trying to open the windows save file dialog box using the below code
WIN_API_DIALOG.SAVE_FILE(‘file’ || ‘.xml’, ‘Save file’, ‘C:’, ‘XML Files (*.xml)|*.XML|’, TRUE , WIN_API.OFN_FLAG_DEFAULT, TRUE)
but i’m getting FRM-40734 Internal Error.
I attached the D2KWUTIL .pll and compiled the form, also i copied the pll along with my forms but still i’m getting error.
Please help me on this…
Thanks in Advance.
Regards,
K.Sathishkumar.
Hi Satish,
Try compiling the pll (compile all) and copy the plx also in the FORMS(90/60)_PATH.
HTH.
Regards,
Arun
FRM-99999 ERRORE 408 OCCURRED FRM-40655 SQL ERROR FORCED ROLLBACK CLEAR FRO
Dear Friends
I am getting this FRM-99999 ERRORE 408 OCCURRED FRM-40655 SQL ERROR FORCED ROLLBACK CLEAR FROM AND RE-ENTER TRANACTION.
FRM-40512 ORACLE ERROR UNABLE TO ISSUE SAVE POINT COMAND.
I am calling the form using the following script :
:global.command_line := ‘C:SALESNEW_ITEMS.FMX’ ;
CALL_FORM(:global.command_line);
go_block(‘COP_ORDER_DETAILS’);
go_record(:global.l_n_curr_rec2);
:COP_ORDER_DETAILS.ITEM_CODE :=:GLOBAL.ITEM_CODE_VAR;
:COP_ORDER_DETAILS.COLOR := :GLOBAL.COLOR_CODE ;
:COP_ORDER_DETAILS.SHAPE_CODE := :GLOBAL.SHAPE_CODE ;
:COP_ORDER_DETAILS.DELIVERY_QUANTITY := :GLOBAL.QTY ;
:COP_ORDER_DETAILS.VOLUME := :GLOBAL.VOLUME;
It works fine for one record, when I try to create another record by calling the called form it gives the above messages.
Waiting for your valuable replay.
Best regards
Jamil
This happens due to dead lock situation
To avoid this problem, add NOWAIT option to the UPDATE and DELETE statements, which returns ORA-00054 error, trap this error and display user defined message like ‘The record is being accessed and try after some time’.
This even improves the performance
because no process waits for the locks preventing dead locks.
If it is due to the UPDATE’s or DELETE’s with base table blocks in the form, in the PRE-UPDATE and PRE-DELETE triggers write SELECT statements to select the particular row with FOR UPDATE NO WAIT option. Handle by trapping the ORA-00054 error
SQL error: Internal database error *** ERROR *** Assertion failed: 201501 (10.0.1.3415)
A SQLA10 production database has been crashing at a customer site.
Here’s the error which displayed when I tried to unload the database…
Unloading «DBA».»schedule_profile» into C:resqresqprod2dbunload719.dat (relative to server)
Unloading «DBA».»schedules» into C:resqresqprod2dbunload720.dat (relative to server)
***** SQL error: Internal database error *** ERROR *** Assertion failed: 201501 (10.0.1.3415)
Page for requested record not a table page or record not present on page — transaction rolled back
The database ‘C:resqresqprod2dbresqprod2.db’ could not be unloaded.
The database ‘C:resqresqprod2dbresqprod2.db’ could not be unloaded.
I think that backups may also have this error.
Can the database be salvaged?
Thank you,
Doug
Hi Doug,
The error seems to be saying that a pointer is pointing to an invalid page.
Actually, the assertion message is suggesting that we were scanning for a row (record) on a particular page where we expected to find it, and didn’t — the table page is likely corrupt.
Does a utility exist which would eliminate all pointers to invalid pages?
No. If the database is corrupted, it is best to move to your database recovery procedure from a valid backup. See KBA 1959391 — How can a SQL Anywhere (stand alone) database be restored from a full or incremental backup?
If you do not have a valid database backup but can still start and connect to the corrupted database (and it seems that you can), you can attempt to salvage the data out of the corrupted database tables manually to extract it to a new database (as Jinwoo suggested). See KBA 1959030 — How To Salvage Data When There are Corrupt Pages in the Database. Using -e to skip tables is appropriate and then trying to select the data that is not contained on invalid pages via the KBA instructions is your best option in this case.
Does sap/sybase offer a recovery service?
No, there is no such «recovery service» underneath SAP and any previous mentions of salvages were one-off contracts underneath Sybase Professional Services, and not a technical support service. These contracts are not available at SAP.
This topic was discussed thoroughly on the SQL Anywhere forum ( http://sqlanywhere-forum.sap.com/ ) previously here and here.
The prevention for this situation is to have properly validated backups, preferably in multiple backup generations to provide many opportunities for recovery. See: http://wiki.scn.sap.com/wiki/x/3QNcFg
Regards,
Jeff Albion
SAP Active Global Support
XMLQuery SQL Error: ORA-00600: internal error code,
Hi guys,
I am trying to use XML feature of Oracle DB. What I am trying to implement is having XMLTYpe field in table and have some values in it and then query that table using XMLQuery(…). I started with example here : http://www.psoug.org/reference/xmlquery.html .
I am able to create table, Insert data into table, but when I tried to run SELECT query it does not work
«SELECT person_id, XMLQuery(
‘for $i in /PDRecord
where $i /PDName = «Daniel Morgan»
order by $i/PDName
return $i/PDName’
passing by value person_data
RETURNING CONTENT) XMLData
FROM person_data; «
It throws error like
«Error report:
SQL Error: ORA-00600: internal error code, arguments: [qmxqrwRewExpr:1], [], [], [], [], [], [], []
00600. 00000 — «internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]»
Am I missing any thing? or is my Oracle 10g DB is not compatible with XMLType ?
Please help.
Hi Marco,
Thanks for replying.
Oracle Database 10g Release 10.2.0.1.0 — Production. so as per you said it should work. I am sorry for being dumb, but I am not DBA guy. can you tell me how to check if XMLDB is installed properly? how can I look at DBA_REGISTRY and what kind of information I will find under DBA_REGISTRY?
BTW I found another way of querying XMLType columns from here http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96620/xdb04cre.htm which uses extract(), existsNode(), etc.. function to accomplish some of the task. As of now I am still digging in it, so not sure which one will be better to use. I mean the link that I showed on my first thread or the above link.
I am still curious why wouldnt my first thread query work.
Thanks again.
Error while trying to connect to a remote SQL Server DB using multiconnect
As part of our business process, we need to connect to a SQL Server DB external to SAP.
We have done the following:
1. We set up an ODBC connection on our SAP sandbox server to the external SQL server DB.
Name: sdsdev
Connection string: sdsdevsqlexpress2008
2. We tested the ODBC connection from within ODBC and it works perfectly
3. Using transaction: DBCO we have set up a DB connection known to SAP that we can use in ABAP to retrieve the data.
It was set up with exactly the same parameters as with the ODBC.
We used the following connection string so it would know to use the ODBC DBSL profile parameters, with the DSN name
being the same as defined in the ODBC: See below …
DB connection: AR_INTERFACE
DBMS: MSS
User Name: ARTransfer
Password: ******
Conn info: MSSQL_DSN=sdsdev
4. We also made sure we installed the DBSL dynamic library (DLL) on the R/3 system server.
5. We ran a small test program to test connectivity … as below …
exec sql .
connect to ‘AR_INTERFACE’
end exec.
right after the above command we check the system log for status. It failed with the following message:
B Wed Feb 09 14:40:40 2011
B Connect to AR_INTERFACE as ARTransfer with MSSQL_DSN=sdsdev
MSSQL_DBNAME=ARTransfer
C Thread ID:3900
C dbmssslib.dll patch info
C patchlevel 0
C patchno 118
C patchcomment Problems with the use of literals in non-unicode
systems (1524929)
C np:(local) connection used on SAPS101B
C OpenOledbConnection : CoCreateInstance failed. rc: 8007007e.
C failed to establish conn to np:(local).
C Retrying without protocol specifier: (local)
C OpenOledbConnection : CoCreateInstance failed. rc: 8007007e.
C failed to establish conn. 0
B ***LOG BY2=> sql error -1 performing CON [dbds#2 @
1056] [dbds 1056 ]
B ***LOG BY0=> <message text not available> [dbds#2 @ 1056] [dbds
1056 ]
The connection failed !
We used all of the information found in OSS Notes we could find.
Has anyone had this problem before ? Is there something obvious we are missing in all this ?
Thank you for your assistance.
Is this Excel or Access? If Excel, try this.
Sub ADOExcelSQLServer()
‘ Carl SQL Server Connection
‘ FOR THIS CODE TO WORK
‘ In VBE you need to go Tools References and check Microsoft Active X Data Objects 2.x library
Dim Cn As ADODB.Connection
Dim Server_Name As String
Dim Database_Name As String
Dim User_ID As String
Dim Password As String
Dim SQLStr As String
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Server_Name = «EXCEL-PCEXCELDEVELOPER» ‘ Enter your server name here
Database_Name = «AdventureWorksLT2012» ‘ Enter your database name here
User_ID = «» ‘ enter your user ID here
Password = «» ‘ Enter your password here
SQLStr = «SELECT * FROM [SalesLT].[Customer]» ‘ Enter your SQL here
Set Cn = New ADODB.Connection
Cn.Open «Driver={SQL Server};Server=» & Server_Name & «;Database=» & Database_Name & _
«;Uid=» & User_ID & «;Pwd=» & Password & «;»
rs.Open SQLStr, Cn, adOpenStatic
‘ Dump to spreadsheet
With Worksheets(«sheet1»).Range(«a1:z500») ‘ Enter your sheet name and range here
.ClearContents
.CopyFromRecordset rs
End With
‘ Tidy up
rs.Close
Set rs = Nothing
Cn.Close
Set Cn = Nothing
End Sub
Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.
An internal database error occurred in the Business Data Connectivity Shared Service. SQL Error Number : 229
Recently i upgraded my SharePoint server 2013 to SP1, after the upgrade i received following message in manage database Status page » Databases running in compatibility range, upgrade recommended»
for Business Data Connectivity Database. Then i ran Sharepoint Configuration wizard, which fixed that error on that page but i am getting a error message while accessing BDCApplication page in manage service applications pagein central admin»
An internal database error occurred in the Business Data Connectivity Shared Service. SQL Error Number : 229
Sys Log :
The BDC Service application failed due to a SQL Exception: SQLServer host WSQLD05DV. The error returned was: ‘The EXECUTE permission was denied on the object ‘proc_ar_GetAdministrationMetadataCatalogByPartitionId’, database ‘sp_BusinessDataConnectivity_DV13’,
schema ‘dbo’.’
I checked the Db role of the service app pool account, it has SPDataAccess permission over the Database. i cant recreate another application without knowing the root cause. I hope i can get better option to troubleshoot the issue.
Thank you
As per the error message, you can at least grant the BDC service application pool account the EXECUTE perimssions on the sp_BusinessDataConnectivity_DV13 database
Edwin Sarmiento SQL Server MVP | Microsoft Certified Master
Blog |
Twitter | LinkedIn
SQL Server High Availability and Disaster Recover Deep Dive Course
Error in using external procedure in PL/SQL Block
After setting up the configuration : Respective entries in
tnsnames.ora
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(CONNECT_DATA = (SID = PLSExtProc)(SERVER=DEDICATED))
and listner.ora :
(SID_LIST = (SID_DESC = (GLOBAL_DBNAME = mymachine )(SID_NAME = mysid)) (SID_DESC = (GLOBAL_DBNAME = mymachine )(SID_NAME = myid1))
(SID_DESC = (GLOBAL_DBNAME = mymachine )(SID_NAME = myid2))
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle9i)
(PROGRAM = extproc)
(ENVS=»EXTPROC_DLLS = ANY» // Added this entry
(SID_DESC =
(GLOBAL_DBNAME = oracle9i)
(ORACLE_HOME = /oracle9i)
(SID_NAME = oracle9i)
(ENVS=»EXTPROC_DLLS= ANY») // Added this entry
Wrote the program as :
===========================================================
#include <stdio.h>
#include<stdlib.h>
void sh(char *command) {
int num;
num = system(command);
===========================================================
Compiled the file (above ) shell.c as :
gcc -c shell.c
Made the library as :
ld -r -o shell.so shell.o
chmod 777shell.so
copied the file to respective Home directories. Made one link to /usr/lib :
which is in LD_LIBRARY_PATH
created the Library as :
CREATE OR REPLACE PROCEDURE shell(command IN char)
AS EXTERNAL
NAME «sh»
LIBRARY shell_lib
LANGUAGE C
PARAMETERS (command string);
So my problem is
when executing the procedure from SQL prompt:
SQL> exec shell(‘any command’);
it throws the following errors :
BEGIN shell(‘ls’); END;
ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: /opt/sotas/bin/shell.so: only ET_DYN and ET_EXEC can be loaded
ORA-06512: at «CDR_ADMIN.SHELL», line 0
ORA-06512: at line 1
Any help or suggestions would be appreciated
Thanks in advance……
Made one Link to /usr/lib
Nikolai,
I have created a simple process flow which only calls the external process. The script is on the same host as the process flow is deployed to.
I have used two diffent values for the command parameter.
1. I placed the full path of the file in the command parameter and left the script parameter blank:
COMMAND: /edwftp/ppas/scripts/ClearPPAS.sh
PARAMETER_LIST:
SUCCESS_THRESHOLD: 0
SCRIPT:
2.I placed the bash command in the command parameter and the full path in the script parameter.
COMMAND: /usr/bin/sh
PARAMETER_LIST:
SUCCESS_THRESHOLD: 0
SCRIPT: /edwftp/ppas/scripts/ClearPPAS.sh
Both of these appear to work as they print out the statements inside the script but the files that are supposed to be removed still remain.
Starting Execution EXTER_FILE
Starting Task EXTER_FILE
Starting Task EXTER_FILE:EXTERNALPROCESS
Removing ActivatedAudit.dat…
Removing ActivatedCustomers.dat…
Removing ActiveAudit.dat…
Removing ActiveCustomers.dat…
Done!
Create the Activated Customers data file…
Create the Active Customers data file…
Done!
WARNING: Log file truncated — see RAB for further information.
/edwftp/ppas/scripts/ActivatedCustomers.sh: /edwftp/ppas/log/ActivatedCustomers.log: cannot create
/edwftp/ppas/scripts/ActiveCustomers.sh: /edwftp/ppas/log/ActiveCustomers.log: cannot create
WARNING: Log file truncated — see RAB for further information.
Completing Task EXTER_FILE:EXTERNALPROCESS
Completing Task EXTER_FILE
Completing Execution EXTER_FILE
The permissions on the /log direcotry are 775. The user I register the file location with owns this directory.
Can’t think of anything else I have missed. I really appreciate your help
Ryan
Getting error while using DYNAMIC SQL
Hi Team,
I am Oracle DBA. I have limited knowledge on PL/SQL. I used below PL/SQL code to drop 50 partitons from one of the table.
I used Dynamic SQL EXECUTE IMMEDIATE to drop partions. But error occured. If I commented EXECUTE IMMEDIATE, procedure executed successfully.
Please suggest me, where i did the mistake. Also please suggest for better code than my code. please find below code and error details.
SQL> ed
Wrote file afiedt.buf
1 DECLARE
2 CURSOR DROP_PARTITON IS select partition_name from user_tab_subpartitions where PARTITION_NAME<=’ABCD_2011_04′;
3 BEGIN
4 for curr IN DROP_PARTITON LOOP
5 DBMS_output.put_line(curr.partition_name);
6 execute immediate(Alter table Table_Name drop partition curr.partition_name);
7 end loop;
8* END;
SQL> /
execute immediate(Alter table BILLCHRG drop partition curr.partition_name);
ERROR at line 6:
ORA-06550: line 6, column 19:
PLS-00103: Encountered the symbol «ALTER» when expecting one of the following:
( — + case mod new not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternative
SQL> ed
Wrote file afiedt.buf
1 DECLARE
2 CURSOR DROP_PARTITON IS select partition_name from user_tab_subpartitions where PARTITION_NAME<=’ABCD_2011_04′;
3 BEGIN
4 for curr IN DROP_PARTITON LOOP
5 DBMS_output.put_line(curr.partition_name);
6 —execute immediate(Alter table TABLE_NAME drop partition curr.partition_name);
7 end loop;
8* END;
SQL> /
ABCD_2009_06
ABCD_2009_06
ABCD_2009_06
BILLCHRG_2011_04
PL/SQL procedure successfully completed.
PL/SQL code runs on the server, inside an Oracle process — thus PL/SQL code cannot dynamically write and display messages to the client. That server process is not connected to any keyboard, mouse or display.
DBMS_OUTPUT can be used. This is a PL/SQL buffer area in that server process that code can write lines of text too. When the server process informs the client that it has completed, the client can now request the contents of the DBMS_OUTPUT buffer and the client can display it on the client device.
This is what set serveroutput on in SQL*Plus does — tell the sqlplus client to request the DBMS_OUTPUT buffer after each Oracle server call made and to display the contents locally.
So to display the SQL command can be done using DBMS_OUTPUT. E.g.
declare
dropPart varchar2(32767);
begin
for c in (select…) loop
dropPart := ‘alter table my_tab drop partition ‘||c.partition_name’;
—// write the SQL command to DBMS_OUTPUT
DBMS_OUTPUT.put_line( dropPart );
—// execute the SQL using a begin..end block in order to catch error
begin
execute immediate dropPart;
DBMS_OUTPUT.put_line( ‘command completed successfully’ );
exception when OTHERS then
DBMS_OUTPUT.put_line( ‘command failed with: ‘||SQLERRM(SQLCODE) );
end;
end loop;
end;So after this code block has been executed and partitions dropped, sqlplus will display the DBMS_OUTPUT generated by this code block.
Error when using Oracle Migration WorkBench (Sql Server 2k to Oracle 8i)
I’m trying to migrate a Sql Server 2k database to an Oracle 8i schema using OMWB. After using BCP to collect metadata information on the source database, I tried to capture the source data model and got a «Capture aborted» message on the progress screen (even though then it appears a dialog window reporting «0 errors and 0 warnings», funny!). Down there is the error log OMWB generated. After reading some posts, I changed some columns of the OMWB dictionary that holds the source database name, but still got the same error. If someone can enlighten me on this toppic, I’d greatly appreciated it.
Here’s the error log of OMWB:
** Oracle Migration Workbench
** Production
** ( Build 20050629 )
** OMWB_HOME: D:DatosDownloadOracleOracle Migration Workbenchomwb
** user language: es
** user region: null
** user timezone:
** file encoding: Cp1252
** java version: 1.4.2_04
** java vendor: Sun Microsystems Inc.
** o.s. arch: x86
** o.s. name: Windows 2000
** o.s. version: 5.0
** Classpath:
..libboot.jar
** Started : Fri Feb 23 17:18:48 GMT-03:00 2007
** Workbench Repository : Oracle8i Enterprise Edition Release 8.1.6.0.0 — Production
With the Partitioning option
JServer Release 8.1.6.0.0 — Production
Repository Connection URL: jdbc:oracle:thin:@ServerCms:1521:sigcewbc
** The following plugins are installed:
** Microsoft Access 2.0/95/97/2000/2002/2003 Plugin, Production Release 10.1.0.4.0
** Microsoft SQLServer 2000 Plugin, Production Release 10.1.0.4.0
** Microsoft SQLServer 6.5 Plugin, Production Release 10.1.0.4.0
** Microsoft SQLServer 7.0 Plugin, Production Release 10.1.0.4.0
** Active Plugin : SQLServer2K
EXCEPTION :SQLServer2KDisconnSourceModelLoad.loadSourceModel(): oracle.mtg.migration.MigrationStopException: java.lang.IndexOutOfBoundsException: Index: 15, Size: 15
** Shutdown : Fri Feb 23 18:00:50 GMT-03:00 2007
Duplicate thread
Error when using Oracle Migration WorkBench (Sql Server 2k to Oracle 8i)