I have a sql file apend.sql that containg it first line as:SET MESSAGE OFFThis file was running fine with SQL*PLUS 8.1 (Oracle 8i)But after migration to Oracle10g and it is running with SQL*Plus 10.2the following message is coming:SP2-0158: unknown SET option "message"Can anyone give the resaon for ...
I have written this slqplus script define fileList=&1 TTITLE SKIP 1 LEFT 'Variazione nel flusso Kler''s TIP' SKIP 2 SET NEWPAGE 1 SET SPACE 0 SET LINESIZE 5000 SET PAGESIZE 20 SET FEEDBACK OFF SET COLSEP '|' SET UNDERLINE OFF SET HEADING ON SPOOL &fileList ...
I have written this slqplus script define fileList=&1 TTITLE SKIP 1 LEFT 'Variazione nel flusso Kler''s TIP' SKIP 2 SET NEWPAGE 1 SET SPACE 0 SET LINESIZE 5000 SET PAGESIZE 20 SET FEEDBACK OFF SET COLSEP '|' SET UNDERLINE OFF SET HEADING ON SPOOL &fileList ...
i'm about to practice with tunings & performance i've try to do from the sqlplus :set aoutotrace traceonly SP2-0158: unknown SET option "aoutotrace" can someone please tell me what is the problem .my d.b version is 10g Release 10.2.0.1.0 ...
this is one of the questions in 1z0-001 exam Examine the code:SET SERVER OUTPUT ONDECLAREv_char_val varchar2(100);BEGINv_char_val:= Hello World,DBMS_OUTPUT.PUT_LINE(v_char_val);ENDSET SERVER OUTPUT OFFThis code is stored in a script file name myproc,sql. Which statement executes thecode in t ...
I am trying to enable autotrace on using the following command.set autotrace trace only in sql prompt and i am getting the following error.SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS reportSP2-0158: unknown SET option "only"Please ...
Hello, I have two problems !1) On machine with Win98 and php 4.06, I try to print whit function "printer_write()", but returns this error : "Warning: couldn't allocate the printerjob in :\programmi\easyphp\www\motorland\stampa.php on line 28" ; with the function "printer_dra ...
I have googled without success in finding an 'easy to understand' list of the following ldap options that can be set with ldap_set_option() function:LDAP_OPT_DEREF,LDAP_OPT_SIZELIMIT,LDAP_OPT_TIMELIMIT,LDAP_OPT_PROTOCOL_VERSION,LDAP_OPT_ERROR_NUMBER,LDAP_OPT_REFERRALS,LDAP_OPT_RESTART,LDAP_OPT_HOST_ ...
When I'm trying to run tkprof I get the next error:SQL> tkprof ora_36172.trc ora36172.prf sys=noSP2-0734: unknown command beginning "tkprof ora..." - rest of line ignored.I tryed to run it from command line - but got the same error.How do I get this to work?Any help is highly appreciate ...
I'm trying to use the SET OPTION to set the DATFMT = *ISO. This doesn't seemto be working. I can see on the compile listings that the DATFMT has beenset to *ISO, but isn't working. I also tried specifing on the RUNSQLSTMcommand. Any ideas? ...
I'm consistently seeing high values of Com_set_option, as much as 20% of total questions. While I'm not sure whether this is entirely a problem, it does seem very high compared to values I've seen discussed online. The question is, how do I go about finding the source(s) of these questions? Document ...
I used sql script for creating DB structure on Oracle 8 with no errors.I got "SP2-0042: unknown command "UNION" - rest of line ignored" error on Oracle 9i.Do you anybody tell me whats wrong ? ...
everyone,i was attemptting to execute a sql statement from an external file. But i got "SP2-0042: unknown command "ï»? - rest of line ignored.". It's works with ANSI but can not based on UTF8 encoding.My file only contains as following : spo db_changesfff.logSPO OFF Anyone has ideas? ...
i want to import a dump file into my database named orcl, and i come accross the same error after executing the import command. my import command is:*************************SQL> imp mvdemo/mvdemo file=mvdemo.dmp full=y ignore=y*************************i use oracle 10g enterprise edition.i create ...
This program fragmet taken from MSDN returns me access violation in ldap_set_option(...):#include <winldap> //include to project also Wldap32.lib...ULONG version = LDAP_VERSION3;ULONG lRtn = LDAP_SUCCESS;LDAP* pSes = NULL;if ((pSes = ldap_init("at", LDAP_PORT)) == NULL) {lRtn ...
I am trying to install Ubuntu 8.1 using Microsoft Virtual PC, but I got this error: unknown boot option.Is there any previous step that needs to be done before installing?P.S. I have no problem with version 7.10 ...
I have just installed 8i on a WinXP. And I have this problem :SQL> dbms_output.put_line('mystring');SP2-0734: unknown command beginning Do you know the reason and the solution please ?Many ...
is it posible to do page set on chart and crosstab in cognos8.2 version??cognos8.2 will support page set option on chart and crosstab report??i am a bar chart in that respective columns are country name ,product name,product margin these 3 columns i have taken in the bar chart.my requirement is i ne ...
I am using Oracle9i rel 2 and have script file as below: (which is similar to the examples shown on http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/win.901/a88826/ch46.htm#1008045)SET VERIFY OFFSET PAGESIZE 200SET MARKUP HTML ON ENTMAP OFFPROMPT Current Session Listing PROMPT TESTSE ...
I am trying to install Oracle 11gR2 for the first time on a test server (I am not a DBA).I have got a message saying that the installation was successful but that I had to set the Oracle_UNQNAME to database unique name in order to be able to start the database control.I have looked at many posts and ...
How can I (successfully) run a script to define OLAP metadata?For example: After running a wizard to create an OLAP dimensionI saved the generated script. But if I try to runit on SQLPlus it fails.The script (that works inside the wizard) is:CREATE DIMENSION MM.REPRESENTADA_DIM LEVEL REPRESENTADA IS ...
I want to set the column '414 Object P&ID Ref2' to the format of a20, however I get the following error because of th '&':col "414 Object P&ID Ref2" format a20 Enter value for id: col "413 Object P&ID Ref1" format a20 SP2-0158: unknown COLUMN option "413"How can I solve this without ...
I am using 'chang data capture' in 9i db. I copy and past and custermize DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE like below.EXECUTE DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE (OWNER => 'cdc',\ CHANGE_TABLE_NAME => 'CLAIM_ct', \CHANGE_SET_NAME => 'SYNC_SET', \SOURCE_SCHEMA => 'RDRDBA ...
Haii try to use dbms_stats to give me a report ofwhat statistics is missing, While it is running ,i got below errorAny idea ,should be appreciatedRegardsmohan SQL> declare2 a dbms_stats.objecttab;3 begin4 dbms_stats.gather_database_stats5 (OPTIONS=>'LIST EMPTY',OBJLIST=>a);6 7 for i in 1 .. ...
After installed the Oracle 10g db, I tried two ways to install html db:1. in the oracle 10g bin directory, I click the sqlplus icon, then a dos terminal show up:(I enter the following info, and get the errors) Enter user-name: sysdba Enter password:sysdbaERROR:ORA-01017: invalid username/password; l ...
Getting this Error Message:SQL> set severoutput onSP2-0735: unknown SET option beginning "severoutpu..."SQL> set severoutput off;SP2-0735: unknown SET option beginning "severoutpu..."Please Help Resolving this. ...
I'm using 10g 10.2.0.1.0 on a Windows server.Within Database Control, I'm trying to schedule a job - this is the error I get:"Validation Error Examine and correct the following errors, then retry the operation:Error - Connection to host as user CORPORATE\jbates failed: IOException in sending Request ...
could you show me how I can set sqlplus in order to get a html report?For example I've tried to writeset pagesize 1000set scan offset markup html on spool on head ' - ' COLUMN field_1 HEADING "Field number one" COLUMN field_2 HEADING "Field number two" SPOOL c:\temp\report.htmlSELECT field_1, field_ ...
I am wondering if there is a method that would allow me to set an option for a single tab, rather than all tabs together? I'm trying to make a tabbed interface that opens another tab when requested, but I'd like to make that tab (and only that tab) closable. I've found this plugin:http://andrew.io/w ...
I am on Oracle9i EE Release 9.2.0.1.0 - Production-WinXP, and try in SQL*PLUS >set autotrace on;- it gives me the errors : SP2-0613..SP2-0611.What can I do ? ...
I'm getting a frequent SP2-0317 error in SQLPlus running in a command window under W2K against Oracle 10.2.Here's an example showing it working intermittently:C:\Duncan\install_new>sqlplus /nologSQL*Plus: Release 10.2.0.2.0 - Production on Thu Jun 21 07:38:13 2007Copyright (c) 1982, 2005, Oracle. ...
After I initializes an image with the resizable({...}) I want to click on a form checkbox to enable ratio. So in the onclick of the check I do .resizeable("option", "aspectRatio", true); but the option isn't updating the resizable. The workaround for me was to re-init the resizable, but thats ...
I'm new at this but I'm just trying to write a stored procedure to do a few things for me as follows. Basically I want to provide a mobile number to my store procedure and get it to query the db - sounds easy enough, however for the life of me I can't work out how to specify the variable in the SET ...
I'm trying to figure something out. I've seen a couple of posts on the internet about it and tried the solutions, but nothing seems to have worked yet. I'm running an application on multiple Tomcat servers using hibernate and jdbc to connect to mysql 5.0.45. Our qps is really really high. When we tu ...
While trying to figure out some of the failing unit tests I came across a failed test that needs to be looked at. When setting dialogs height explicitly the actual height is 18 pixels higher then specified. Test case http://jsbin.com/equce/editTicket: http://dev.jqueryui.com/ticket/5392 ...
I thought this may be because catexp.sql has not been run on this Oracle 9i database, however the role EXP_FULL_DATABASE exists.Shall i try re-running catexp.sql However, i only have the system password and i think i have to run it as 'sys' (can i run it as system ?)-is there a role that system will ...
On a 64bit install of oracle, i'm trying to run a script within sqlplus such as @c:/create.sqlhowever when i run that, somehow it seems the @ sign as a ■ and screws up my script execution. Has anyone seen this before? ...
I have two pages with the same select list. I would like page 1 to drive what is defaulted in the select list on page 2.So if I have a select list with values 1,2,3,4,5 in it and page 1 has the value of 4 in it; I would like page 2 to default to 4 as well. How do I do this? Perhaps I have been stari ...
Can anyone explain why the following does not work under solaris unix sqlplus SQL*Plus: Release 3.2.3.0.0 - Production on Wed Aug 13 17:43:20 2008Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. Connected to:Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit ProductionJServer Rel ...
Can any one provide me solution. i unable to shutdown my dabase it showing below message when i make my database into downmode. SQL*Plus: Release 8.0.6.0.0 - Production on Tue Aug 19 14:19:58 2008(c) Copyright 1999 Oracle Corporation. All rights reserved.Enter user-name: sys as sysdbaConnected to:Or ...
I am using Oracle 7.3 under SCO Unix. I want to set autotrace on, but it says that"unknown SET option "autotrace"What would be the problem? ...
Hai everybodyi am using oracle 10g 10.2.0.1.0. i wanted to use the data pump commands like expdp and impdp.When i tried ' expdp' the system displayedSP2-0042: unknown command "expdp" - rest of line ignored.then after searching in the net i have created a directory 'my_dump_dir' in oracle directory a ...
According to msdn IPPROTO_IPV6 page, it should be supported. But the "setsockopt" line of code gives 10022(WSAEINVAL: The level parameter is not valid, or the information in optval parameter is not valid.)IPV6_MREQ imr;TCHAR *all_nodes = L"ff02::1";//get IPv6 multicast address fr ...
i have a initdev.ora file as belowinitdev.ora db_name = DEVdb_block_size = 8192db_files = 200compatible = 9.2.0.1.0db_file_multiblock_read_count = 32db_block_buffers = 9600shared_pool_size =40000000SORT_AREA_size=4096000log_checkpoint_interval = 10000processes = 200dml_locks = 500log_buffer = 196608 ...
this has been posted before, but any hints i can find do get me further.this is my code:$ds=ldap_connect($ldaphost,$ldapport);if ($ds) {if (ldap_set_option($ds, LDAP_OPT_PROTOCOL_VERSION, 3)) {} else {echo "Failed to set protocol version to 3";}$r=@ldap_bind($ds, $dn_uid, $searchpass);if ( ...
...PHP expert, JavaScript Novice......long story short, I need to use some JavaScript to grab the -text value- (NOT the input value) of a selected option box on a page.What I have:<SCRIPT type="text/javascript">var selects = document.getElementsByTagName('option');for(i=0; i < sel ...
Why I'm getting this error only when I run it from the script i.e @"path..." INSERT INTO CI_ALG_TYPE_L ( ALG_TYPE_CD, LANGUAGE_CD, DESCR50, DESCRLONG, OWNER_FLG ) VALUES ('CM-DR-SVC ', 'ENG', 'Calculate deposit amt based on local requirements', 'This Deposit Recommendation Algorithm will calculate t ...
I'm just about to lose my mind.I'm running the following in SQL Plus - set echo offset feedback offset linesize 1000set sqlprompt ''spool c:\TEMP2\App_Eng1.csv replaceSelect A.OBJECTOWNERID||','||B.OBJECTVALUE1 from PSPROJECTITEM B, PSAEAPPLDEFN AWhere B.PROJECTNAME = 'PRJ732075'and B.SOURCESTATUS = ...
i have the following scriptSET NEWPAGE NONE;SET SPACE 0;SET LINESIZE 32767;SET PAGESIZE 0;SET ECHO OFF;SET FEEDBACK OFF;SET VERIFY OFF;SET HEADING OFF;SET MARKUP HTML OFF;SET TERMOUT OFF;SET TRIMOUT ON;SET TRIMSPOOL ON;SET TAB OFF;SET LONG 4000;SET LONGCHUNKSIZE 4000;SET WRAP OFF;ALTER SESSION SET N ...
I am using oracle 10g datbase.and trying to create a list of tables of 300 tables - a sampel is given belowCREATE TABLE "SCHM1"."HOLIDAYS"( "DATE" DATE NOT NULL ENABLE,"DESCR" VARCHAR2(40),"EXTRA_HOURS" NUMBER(2,0),"HOLIDAY_GROUP" VARCHAR2(5) NOT NULL ENABLE,"CREATED_BY" VARCHAR2(12),"CREATED_ON" DA ...