re: do not know why the script does not run ??

hi! Guys ,

Heres the code ..

type n_array is table of number index by binary_integer;
type d_array is table of varchar2(10) index by binary_integer;

cursor c1 is select empno,ename from emp;

v_empno n_array;
v_ename d_array;

open c1;
fetch c1 bulk collect into v_empno,v_ename;
forall i in 1..v_empno.count
update emp
set sal = 0
where empno = v_empno(i);
exit when c1%notfound;
end loop;
end ;
Here's my error message ..

scott@ORACLE> @c:\ex.sql
ERROR at line 1:
ORA-03113: end-of-file on communication channel

ORA-24323: value not allowed
Error accessing package DBMS_APPLICATION_INFO
ORA-03114: not connected to ORACLE


What is the problem and how can I fix it to run the program

Posted On: Friday 16th of November 2012 01:19:36 AM Total Views:  288
View Complete with Replies

Related Messages:

Redo log resize   (161 Views)
we can a large batch job run monthly that insert lots of record and also query and join some huge tables .. two questions : 1- Can I user SET TRANSACTION TO BIG_ROLLBACK inside stored procedure ( Oracle 8.0.5 ) to prevent regular rollback blow out 2- Do I need to resie redo log groups and files to prevent too many log switch and probably hang Generally please tell me what cuation I have to do in this kind of large scale process
Redo log files are used to roll back uncommitted transactions???   (101 Views)
Which two statements concerning redo log files are true (Choose two.) 1.Redo log files store committed changes to the database. 2.Redo log files are used to roll back uncommitted transactions. 3.Only one redo log file is required. 4.Changes are written to the redo log files when the redo log buffer is 3/4 full. 5.Redo log files are used instead of archiving for point-in-time recovery. Apparently 1&2 are correct. But How can 2 be correct I don't understand Cheers Gus
recreate Repository   (129 Views)
! I want recreate Repository. Version Oracle is I do delete repository. Command: /opt/app/oracle/10.1.0/sysman/admin/emdrep/bin/RepManager -connect "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= se)))" -sys_password password -action drop Log: [05-06-2008 07:49:45] Checking SYS Credentials ... [05-06-2008 07:49:45] OK. [05-06-2008 07:49:45] Dropping the repository.. [05-06-2008 07:49:45] Quiescing DB ... [05-06-2008 07:49:45] Failed. [05-06-2008 07:49:45] Checking for Repos User ... [05-06-2008 07:49:45] Does not Exist. [05-06-2008 07:49:45] Repos User does not exist ... Continuing with cleanup ... [05-06-2008 07:49:45] Dropping Roles/Synonymns/Tablespaces ... [05-06-2008 07:49:46] Done. [05-06-2008 07:49:46] Unquiescing DB ... [05-06-2008 07:49:46] Done. [05-06-2008 07:49:46] Dropped Repository Successfully. Next I do create repository. Command /opt/app/oracle/10.1.0/sysman/admin/emdrep/bin/RepManager -connect "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= se)))" -sys_password password -action create Log(general part): [05-06-2008 07:49:59] Checking SYS Credentials ... [05-06-2008 07:49:59] OK. [05-06-2008 07:49:59] Checking DB Init Parameters ... [05-06-2008 07:49:59] OK. [05-06-2008 07:49:59] Checking for Repos User ... [05-06-2008 07:49:59] Does not Exist. [05-06-2008 07:49:59] Loading necessary DB objects ... [05-06-2008 07:49:59] Checking DB Object (DBMS_SHARED_POOL , PACKAGE) ... [05-06-2008 07:49:59] Exists. [05-06-2008 07:49:59] DBMS POOL package exists. [05-06-2008 07:49:59] Done Loading necessary DB objects [05-06-2008 07:49:59] Creating repos user ... [05-06-2008 07:50:05] Done. [05-06-2008 07:50:05] Creating EM Schema ... SP2-0310: unable to open file "/opt/app/oracle/10.1.0/sysman/admin/emdrep/sql/ocs/latest/ovf/ovf_pkgdefs.sql" declare * ERROR at line 1: ORA-20204: User does not exist: SYSMAN ORA-06512: at "SYSMAN.MGMT_USER", line 122 ORA-06512: at "SYSMAN.MGMT_JOBS", line 142 ORA-06512: at "SYSMAN.MGMT_JOBS", line 78 ORA-06512: at line 16 [05-06-2008 08:08:31] Failed. [05-06-2008 08:08:31] Repository Creation failed. Failed to create repository schema. Log other: Enter repository user name : sysman Enter repository user password : Enter MetaLink user name : Enter MetaLink user password : Getting temporary tablespace from database... Found temporary tablespace: TEMP Checking SYS Credentials ... OK. Checking DB Init Parameters ... OK. Checking for Repos User ... Does not Exist. Loading necessary DB objects ... Checking DB Object (DBMS_SHARED_POOL , PACKAGE) ... Exists. DBMS POOL package exists. Done Loading necessary DB objects Creating repos user ... Done. Creating EM Schema ... Failed. Repository Creation failed. Failed to create repository schema. Next I do query: select count(*) from all_users where username = UPPER('sysman'); Result: 1 Where is problem
recreate indexes   (147 Views)
Sorry Instead of creating new thread I messed another thread This may be small question for Guru's . But I do have a question , Is there any advantage to recreate indexes with same extents and same size etc., and if I delete a row in a table will it be effected in index too Raghu
recovery...   (126 Views)
hi, i am taking closed backups daily. Script are stored in Crontab. I issued command shutdown immediatly but it was in hang state. Can any one tell that where to check and how to soleve the problem without losing any thing. O/S is Unix.
recovery question   (114 Views)
, i have to attend a recovery scenario where my database 7.3.4 will need to be recovered from a cold backup with archive log mode option. so i watnedt o make sure that the following steps are correct to recovery a database using cold backup then apply archive logs to bring up to the date.. recovery database files... startup database w/ mount option... then recover how will Oracle know to apply all the archive logs rename archive logs to redo logs then let oracle to automatic recovery :
recovery a psuedo "standby"   (113 Views)
Hi . OS Windows 2000 Oracle I'm looking for some clarification here. I'm on a site that manually maintains a backup database. i.e. The archive logs from the primary database are copied to the backup server and applied as "recover database using backup control file until cancel". The database is not mounted as standby and the logs are copied via scheduled script. I've always found B&R a bit tricky so I have 2 questions. 1. Since this backup database is not using a backup control file what does the syntax "using backup control file" tell Oracle to do 2. How does Oracle know what archive logs to apply or does it just apply all logs available Any thoughts would be appreciated.
recovering in noarchive log mode while redo logs are not overwritten   (173 Views)
Here is an excerpt from offical Oracle material: For a database in noarchivelog mode, you do not have to restore all Oracle files if no redo log file has been over-written since the last backup. Scenerio: - There are two redo logs for a database - A closed database backup was taken at log sequence 144. - While the database was at log sequence 145, datafile 2 was lost Result: Since log sequence 144 has not been over-written, just datafile number 2 can be restored and recovered manually. ---- My question is: after restoring datafile #2, it has log sequence 144 while the other files have 145. Do I need to mount it and use "recover" command to bring it up to 145, or it is done automatically when I do "startup"
recover from the last full hot database backup   (88 Views)
Hi Guys, I just want to ascertain this fact since I still read many contradictories floating around. Say, I had a full hot database backup yesterday and today the database node has exploded for some reason. I have the last full HOT database backup and all the archive logs generated since. The control files were backed up along in the full backup. The question is : will I be able to recover the database completely without resetting logs Some said we can only recover completely from a full COLD database backup. Well, I tried the scenario and found that I can recover from the HOT one without having any archived logs generated BEFORE the full backup. Can you shed some light here
recover db until cancel   (121 Views)
At 9:00 one of the online redolog files has been dropped. at 9:05 the foll cmd is executed recover database until cancel Q)How does orcle know the redolog file is dropped at 9:00. I mean where does oracle get the timestamp info and recreates the redolg file of the last known good configuration.
recover database from backup   (94 Views)
This is just for my information. I can't test it. May be somebody out there has come across this. During system backup, database is still up. If I restore all files to other server, can I still open the database Do I need to recover
Rebuilding indexes and moving tables to different tablespaces   (103 Views)
I want to rebuild indexes to a different tablespace Although we use alter index index_name rebuild tablespace ts1 online; users are making transaction and using indexes is there any harm involved rebuilding indexes and moving tables to a different tablespaces should we perform this activity when there are no transactions or we can perform at any time i have some confusion about it so can u please help me in this regard
rebuild index v.s. create new index   (112 Views)
Since I need to free up some unused space inside a giant tablespace, I basically have to decide if I need to drop the indexes and recreate them after the tablespace being resized, or rebuild the indexes to a different tablespace and rebuild it back after we resized the original tablespace. One of the deciding factor here is which one is more expensive -- rebuild index or create new index If they are pretty much the same expense wise, then I would prefer to do drop and recreate, 'cause if we choose rebuild, we'll have to do rebuild twice (first to rebuild to temp tablespace and then rebuild it back to original tablespace). If rebuild is significant cheaper than create new indexes, then I will prefer rebuild as it will offer uninterrupted availablility of the tables, while drop/recreate index will need some down time (unless they won't mind the poor performance). What do you gurus think Any input is highly appreciated! Elaine
reasons to be slow ...   (125 Views)
the database I talk about has the following basic data: OS: Win2000 SP3 DB-Version: with patch set the problem I got is that the performance of the db drops down after about two weeks the db is running. contraindications: - the buffer cach hit ratio is about 99 percent - LIBRARY CACHE" STATISTIK is about 0.01 percent - rollback contention is low - redo log contention was not so good but I doubled the log_buffer parameter - the RAM is used to the half - the maschine got 4 cpus - the network trafic is low Do you know any REASON or BUG that can slow down the performance of the database and the applications that taking hold Thank you for reading this and maybe helping me! Christian
read only tablespace / backup procedure   (125 Views)
Hi , I currently am operating in Noarchivelog mode and performing full cold backups once a week. Stay Calm, we don't have many updates and can afford a week loss. Backups are script based. Question is: I want to put several huge tablespaces in read only mode. Do I have to be in archivelog mode Can I still perform cold weekly backups, minus the RO tbsp datafiles How will this recover If anyone has a backup/recovery strategy for read only, please share.
RE: v$sqlarea   (131 Views)
Hi Everybody , could anybody provide me with sql script to find the top two expensive sql statements . and to find two mostly used sql statements .
re: sqlplus directory .. error reading file   (229 Views)
hi!, I have a sql file in directory c:\dbscripts directory called abc.sql abc.sql calls file def.sql in c:\dbscripts directory and xyz.sql in c:\dbscripts\wmi subdirectory when I open the file to run "abc.sql" from sql*plus using file -> open it is erroring out saying that the ORA-00933: SQL command not properly ended I suspect it has to do with the buffer size ..!! or with recognizing the subdirectory "wmi" ... Can anybody help me out and tell me how to rectify it or point me to the relevant documentation I do not have a metalink id ..
re: puzzling performance of query   (107 Views)
hi! , I have a query that is taking 14-15 seconds to complete in prod onsite.. Its taking for ever to run about 45 minutes in a similar environment simulated at our site .. When I look at the explain plans they look exactly the same except for the order of the indexes ...!!! Could that be the problem for the poor performance at our site Any ideas , hints , help would be appreciated ...!!! i did the following on our site execute dbms_stats.gather_schema_stats('schema_name) ..
re: interpreting explain plan   (108 Views)
hi! Guys , Can some body be kind enough to post a sample explain plan and show how to interpret it
re: getting oracle to recognize multiple directories   (104 Views)
hi! , How would one get oracle to recognize multiple directories "to run file from one directory " which internallly calls "file from another directory" Many