Today, I am working on an OA report. I use a stored procedure to calculate some data. When doing a for XXX in xxxx loop end loop; loop,
I never knew it was Mao. I cannot catch the no_data_found exception in for any more. Once this no_data_found occurs
Oracle will automatically Jump Out Of The for loop, but I don't know where the error occurred. It was a depressing hour. Shit.
Later I remembered that PL/SQL tools could be debugged.
Today, I am working on an OA report. I use a stored procedure to calculate some data. When doing a for xxx in xxxx loop end loop; loop, I never knew it was Mao. I can't catch the no_data_found exception in for any more. Once this no_data_found Oracle occurs, it automatically jumps out of the for loop, but I don't know what went wrong, that was depressing for an hour. Shit. Later I remembered that pl/SQL tools could be debugged.Www.2cto.com, But I thin
64-bit SQL Server2008 link Access Oracle Process Rollup workaround recordAfter a few days of online search for information, experiments, and finally unicom.Environment: System: Win, SqlServer2008 R2, Connection oracle10gOn the SqlServer2008 R2 machine, you need to install the Oracle
The processor changed from 32 bits to 64 bits, and after the Oracle software was replaced, the db I chose to migrate the cold standby direct hook, and then the problem was encountered after the migration.
After a successful mount of DB, errors such as ora-06553:pls-801:internal error [56319] occur when connecting through an application or Third-party tools such as Plsql developer. The workaround is as foll
Tags: folder copy files SQL Instant DMI 1.2 directory Oracle System installation1. Unzip the J:\ software \ (computer) Computer class software \oracle\plsqldeveloper\instantclient_11_2To product under the Oracle installation directoryC:\app\Administrator\product2, put the C:\app\Administrator\product\11.2.0\dbhome_1 directoryThe network folder is copied to the ex
Label:64-bit operating system how to use Plsql to connect remote or local Oracle data in the case of locally installed Oracle databasesCurrently Plsql only supports 32-bit Oracle clients, how can I use Plsql to connect data with a
./iNodeClient.shThe result is another problem, similar to the previous one.zengwh@zengwh:/usr/iNodeClient$ ./iNodeClient.shzengwh@zengwh:/usr/iNodeClient$ /usr/iNodeClient/.iNode/iNodeClient:whilelibraries: libgtk-x11-2.0.so.0:file:Noor directoryI'll use the following command to resolvesudo apt-get install libgtk2 .0-0 :i386 LIBNSS3 :i386 libcurl3-gnutls :i386 libidn11 :i386 libpango1 .0-0 :i386 libpangox-1 .0-0 :i386 libpangoxft-1 .0-0 :i386 librtmp0 :i386 libxft2 :i386
Oracle
Look at these two links first:
http://www.cnoug.org/viewthread.php?tid=71
http://www.cnoug.org/viewthread.php?tid=214
It says some methods of $file, in which Oracle uses more of this method
In Kyle Hailey's documentation, another way was suggested:
Sql> Connect/as SYSDBA
Sql> desc X$KSMMEM
Name Type
------------------------------------- ---------
ADDR RAW (4)
INDX number
INST_ID number
Ksmmmval RA
1. After installing Oracle 11G client, you can find it in the Start menu
Select Netca-> Local Network service name configuration
Select Add Local network service name configuration
Service Name here: refers to the name of the database
Setting up C/S client to select TCP type in Network
Enter the IP addre
If you use putty in 64-bit win7, the following error occurs: SSH, Telnet and Rlogin client has stopped working. This prompt is displayed due to security reasons, if Windows 7 has automatically disabled the telnet service, use the following steps to enable telnet: 1. "Control Panel"-> "program"-> "turn on or off windows" and find "telnet Server" and "telnet
First, go to Oracle's website to download an Oracle 11g Client (My 11g Oracle), but you need to apply for an Oracle account before you can download it.Current: http://www.oracle.com/technetwork/topics/winsoft-085727.htmlThis is a
Issue: Win8 on a 64-bit system that uses PLSQL developer to connect to a local Oracle database can cause an inexplicable problem, and the error box may even be empty.Reason: According to the internet, the reason is estimated to install 64-bit
Test environment: Oracle Enterprise Linux 64-bit (5.8 version number) + Oracle 11g 64-bitDescription: The oracle11g64-bit software is installed at/u01/app/
For Windows 64-bit Oracle 11G 64-bit, PLSQL developer has the following problems:
1. The database drop-down box is blank:2. Enter the username, password, and database. The logon dialog box is displayed: Reference initialation
CentOS 6.5_x64 Install Oracle 11g R2 installation Environment: Operating system: centos6.5_x64 Desktop Host Name: OracleDB Memory: 1G (official minimum requirements 1G) hard drive: 40G (4.29G and 1.7G data required for enterprise installation) File) Pre-installation System Preparation: #设置操作系统 system support Red Hat Enterprise Linux 6,centos 6 is actually RHEL6, but Ora
First, install the driverIf you are using a 32-bit win2003 operating system, there will be a system-brought Microsoft OLE DB Provider for Oracle driver, so no additional preparation is required, but if you are using a 64-bit system, this driver is not, and Microsoft does not provide the
Tags: and file read content color RAR client Span dialog boxA new 64-bit Win7 system has recently been installed that requires an Oracle database for work, and a database that is managed and maintained by the company's it dba. We only need to connect to use it, so I installed the O
The project used a 64-bit Oracle, but the local use of 32-bit plsql, so the Chinese is always displayed in the Plsql is garbled, began to think it is a database problem, after verifying the database has no problem, the Internet search for an afternoon, finally got the answer. Originally need to create a new bat file in
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.