I am getting "sqlnet message from client" in top 5 wait events and sql*net trace .We are getting waiting for SQL*Net message from client for a huge number of sessions with huge total waits. From session level sql tracing
we figured that the whole query took 7 to 8 Hours to complete. But in trace we see query executed within 10 to 12 minutes and after that it was showing waiting for SQL*Net message from client till next 7 hours.
I have installed SQL navigator 5.0 version in my PC. Once it has been successfully installed, I clicked on SQL navigator icon in my PC after that it's prompted me for asking authorization Key. I have entered the following key.
3-37993-18701-28024-78347
Once I have entered the key is is prompting me for asking site message. what message I should enter.
Am using the SQL*PLus tool via a command line to execute some simple "select" scripts. Scripts work fine in what they produce - except for something that is missing occasionally.
For SOME scripts, I'm getting no "xx Rows Selected" type messages at the bottom and I can't figure out why. When no data si returned in some (different) scripts I do get a "no rows selected" message. Am looking for this message in all outputs as an "end of report"-style marker.
No complicated SQL logic and I have the following standard settings applied into each script.
set linesize 500 set pagesize 50000 set tab off set wrap off set colsep '|'
I have 20 years of coding experience so it's not a basic error....albeit I'm far more familiar with MS SQL Server product set as well as the PL/SQL Developer client front ends for Oracle.
I wiuld like to suppress oracle messages conditionally. I am running oracle view creation scripts from command line, After successful view creation, it is showing me "view created" message. To suppress this, I have created following
set serveroutput on format wrapped; SET TERMOUT OFF @@test1.sql SET TERMOUT ON
[Code]....
but still it is giving me "PL/SQL procedure successfully created" message along with "'View test831 created successfully". I need to suppress "PL/SQL procedure successfully created".
Actually I have to modify set SQLNET.INBOUND_CONNECT_TIMEOUT,TRACE_LEVEL_CLIENT in SQL net .ora . But I cant fine that file in $ORACLE_ HOME /network/admin directory.
But I found this other files like listener.ora and tnsname.ora in the same directory.
When I give sho parameter nalue in listener prompt it shows some values. Is it showing default values without sqlnet file (is it fauture of Oracle11g).
how to integrate SQLnet & c and I'm quite losted at the moment.
Searching with google gives some random stuff, which does seems to be irrelevant.some oracle db somewhere and need for good way to use that remote db (one solution seems to be using SQLnet).
I am trying to look at wait events for a long running query in TOAD.I start the query on one instance of TOAD and open the Session Browser on another instance.But I am surprised to find that in "TOtal Waits" on the RHS-> SQL*Net message from client is the longest time taking and is already -> 178577 units whereas I have just started the query.
Whereas in the Current Waits it shows DB File Scattered Read currectly as some seconds.
I'm migrating some forms from 6i to 9i and one of them has to use the webutil library, but when I execute the form in the IE, a message appear and I don't know from where because I haven't made it. The message say: "Confirme el mensaje" This is a print of the message,
I have written a small code while going through the PL/SQL guide but I got a message for the BIND VARIABLE. I don't think I have used any bind variable in this code.
<<outer>> declare v_sal1 number(7,2) := 60000; v_comm number(7,2) : v_sal1 * 0.20; v_message varchar2(2000) := 'eligible for commission'; begin [code]........
Currently, I am running 4 separate queries in order to retrieve specific data from a XML file. Is there a way of extracting all 4 values via XML tags in a single query - e.g. :
At the moment, I am extracting the required info as follows.
Example query 1: message_content, 2000, 2303 > retrieves starting point for an error header
select ml.message_reference, UTL_RAW.CAST_TO_VARCHAR2 (dbms_lob.substr(message_content, 2000, 2303)) from table.msg_archive ma, table.msg_log ml where ma.message_id = ml.message_id and ml.message__cd = 'MP_XML' and ml.message_reference in (456123)
Once retrieved, I transfer to Excel and use a formula to extract the specific header (e.g. using =MID(B1,1,11))
Example query 2: message_content, 2000, 581 > retrieves the starting point for a user id.
select ml.message_reference, UTL_RAW.CAST_TO_VARCHAR2 (dbms_lob.substr(message_content, 2000, 581)) from table.msg_archive ma, table.msg_log ml where ma.message_id = ml.message_id and ml.message__cd = 'MP_XML' and ml.message_reference in (456123)
We have a queue in which the message is coming from external system. The payload of the queue table is a PL/SQL record type. Once we get the message in the queue, we de-queue the message and read through the PL/SQL type collection and process the message.
From the below query, we are able to convert the PL/SQL collection message to XML message and see the data.
SELECT dbms_xmlgen.getxml ('SELECT USER_DATA FROM <Queue_table> X WHERE X.USER_DATA.SALE_ORDER.P_HEADER_REC.ORIG_SYS_DOCUMENT_REF=800501298') FROM dual;
The new requirement is the message would come in a XML message in the queue. So my question is, is there any way through which the XML message can be converted to the PL/SQL record structure directly (it would be the opposite operation of the above query).
While I am inserting and updating the values in the oracle database its showing a message 'FRM-40401 - No changes to save.' I don't want this message to be shown. How can I do that?
I have a form with multiple data block. When i want to query and go to next record then this displayed a message "Do you want save changes". But i would like to stop this message(i.e would not see the message) is it possible.
I have created a procedure, which should be executed on the below condition with EXECUTE IMMEDIATE COMMAND. But i am getting error.
The error shows the procedure/function name is not existing. But it is exist.
SQL> 1 Declare 2 a varchar2(20); 3 b varchar2(20); 4 c varchar2(1000); 5 begin 6 select to_char(sysdate,'day') into a 7 from dual; 8 select to_char(sysdate,'HH24') into b 9 from dual; 10 if 11 (a='friday' and b>=22) 12 or 13 (a='saturday' and b<=6) 14 or 15 (a='wednesday' and b>=9) 16 then 17 begin 18 EXECUTE IMMEDIATE ('begin'||BACKUP_AUTO_execute_bat_file||'end;'); 19 end; 20 else 21 null; 22 end if; 23* end; SQL> / EXECUTE IMMEDIATE ('begin'||BACKUP_AUTO_execute_bat_file||'end;'); * ERROR at line 18: ORA-06550: line 18, column 32: PLS-00222: no function with name 'BACKUP_AUTO_EXECUTE_BAT_FILE' exists in this scope ORA-06550: line 18, column 4: PL/SQL: Statement ignored
I created a report and in this report there is a likeable colummn and when its been cliked I need its show a message box containing a text that cames from field on a tables in my database.
procedure PROC1(id number) is begin.... exception when others dbms_output.put_line('other exception'); when no_data_found dbms_output.put_line('no data'); end;
now I have an other procedure Porcedure PROC2 begin PROC1(23412); end;
now if the PROC1 returns an exception message I would like to assign the message to variable in PROC2 and display.
i 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
I've set up a query that creates 2 columns 'UVLCredit' and 'UVLDebit' and what I'm trying to do is subtract the 'UVLDebit' column from the 'UVLCredit' column and have the resulting value show up in a column called 'UVLTotal.
I'm multiplying 1 column times another to create a new column called UVLCredit, and then doing it again (with a different column) to create a 2nd new column called UVLDebit...the last thing I'm trying to do is to take the results of the 1st new column and subtract the results of the 2nd newly created column to create a 3rd new column called UVLTotal. The error states that the 'UVLDebit' column is an invalid identifier.
See code below....
CODESELECT T.PO_RELEASE_NBR, T.PO_LINE_STATUS, T.FACILITY, TI.STATUS_DATE, TI.QTY_ORDERED_UP, TI.PO_UNIT_PRICE, TI.QTY_REC_TOTAL_UP, TI.QTY_INVOICED_UP, [b]sum(TI.PO_UNIT_PRICE) * (TI.QTY_REC_TOTAL_UP) as "UVLCredit", sum(TI.PO_UNIT_PRICE) * (TI.QTY_INVOICED_UP) as "UVLDebit", [code]........
I am facing one confusion with canvas changing and message displaying issue i have one login page. in that there are three fields username,password and department in the department i having 5 departments including salesandmarketing
the requirement once i entered every credentials correctly and i am logging in as salesandmarketing. When the salesandmarketing canvas opens a message should display saying "you are successfully entered into sales and marketing".
i have my home page as content canvas and sales and marketing as tab canvasi need to do the same message when i am entering into 5 departments with corresponding department name in the message end instead of salesandmarketing is it possible to do with when_new_canvas