Home > Oracle Development
Oracle Development
Oracle Development forum discussing administration, Oracle queries, and other Oracle-related topics. Oracle is known as one of the most robust multi-platform relational databases available.
Trouble with Oracle.DataAccess.dll
Our client has Windows 2003 Server machine with Oracle 10. Unfortunately, we have to install there older web application (c#, aspx) using Oracle.DataAccess version 9.2.0.2102. This app can't use Oracle 10 due implementation details. I trie...
Our client has Windows 2003 Server machine with Oracle 10. Unfortunately, we have to install there older web application (c#, aspx) using Oracle.DataAccess version 9.2.0.2102. This app can't use Oracle 10 due implementation details. I trie...
answer(1) view(1,219) status(
)
)
how to close window in oracle forms 6i
Hi I need help with code for "when button pressed" trigger that will close the current window and displays another window. thanks in advance.
Hi I need help with code for "when button pressed" trigger that will close the current window and displays another window. thanks in advance.
answer(4) view(949) status(
)
)
NOT FOUND -The requested URL /apex/wwv_flow.show was not found on this server
im getting this error after running pl/sql program...i tried removing the indentations and slammed the code to the left side...but it still does'nt work...can anyone please help me out...
im getting this error after running pl/sql program...i tried removing the indentations and slammed the code to the left side...but it still does'nt work...can anyone please help me out...
answer(0) view(42) status()
)
Ora-01041
Hi, I am not sure if this is the right place to pose this question, but if not maybe someone can point me to the correct forum. I have an oracle 10 xe database. I have a user named lotions. I am trying to connect to this database usin...
Hi, I am not sure if this is the right place to pose this question, but if not maybe someone can point me to the correct forum. I have an oracle 10 xe database. I have a user named lotions. I am trying to connect to this database usin...
answer(2) view(684) status()
)
inet_ntoa equivalent in oracle
convert 192.168.27.44 to an integer for comparsion.
convert 192.168.27.44 to an integer for comparsion.
answer(0) view(65) status()
)
Cannot read record when convert data to excel
I am writing a plsql code to transfer a report to excel. Due to in ";" or new line character in the data, when exporting to excel, I am getting message box "cannot read record 6" and more when opening the excel file. Any soluti...
I am writing a plsql code to transfer a report to excel. Due to in ";" or new line character in the data, when exporting to excel, I am getting message box "cannot read record 6" and more when opening the excel file. Any soluti...
answer(0) view(57) status()
)
How to take database export through form 6i
Please tell me How to take database export through form 6i. Thanks in advanced! p.s. I tried with procedure Win_Api_Shell.WinExec in event button-pressed in syntax Win_Api_Shell.WinExec('C:\oracle\dev6i\BIN\ifrun60.exe module=G:\prg_o...
Please tell me How to take database export through form 6i. Thanks in advanced! p.s. I tried with procedure Win_Api_Shell.WinExec in event button-pressed in syntax Win_Api_Shell.WinExec('C:\oracle\dev6i\BIN\ifrun60.exe module=G:\prg_o...
answer(1) view(767) status()
)
Installing Personal Oracle 8i on Windows XP
Getting error message:"Invalid staging area. There are no top level components for Windows NT available for install from this staging area." Please guide how resolve this issue.
Getting error message:"Invalid staging area. There are no top level components for Windows NT available for install from this staging area." Please guide how resolve this issue.
answer(0) view(65) status()
)
"Oracle Error: -22275/ORA-22275:invalid LOB locator specified"/dbms_lob.freetemporary
/* Function pck_raw.if_read_long_raw() */ function if_read_long_raw(ps_tableName in varchar2, ps_rawColumn in varchar2, ps_pkColumn in varchar2, pde_pkValue in number, pb_blobData out nocopy blob, pde_ht_id out number) return number is ...
/* Function pck_raw.if_read_long_raw() */ function if_read_long_raw(ps_tableName in varchar2, ps_rawColumn in varchar2, ps_pkColumn in varchar2, pde_pkValue in number, pb_blobData out nocopy blob, pde_ht_id out number) return number is ...
answer(0) view(378) status()
)
Row-00060
Hi, I'm Working with ORACLE 8i, IIS and VB6 with AD0. I'm also using the Oracle ODBC driver to be able to work with blobs ! Sometimes I receive the error "ROW-00060 : Internal Error : [dahprepare, 1]". I don't know wha...
Hi, I'm Working with ORACLE 8i, IIS and VB6 with AD0. I'm also using the Oracle ODBC driver to be able to work with blobs ! Sometimes I receive the error "ROW-00060 : Internal Error : [dahprepare, 1]". I don't know wha...
answer(1) view(687) status()
)
Problems with SQL Query and a partial search - PLEASE HELP !
First of all I would like to say HI to everyone here ! and I hope I can get my little stupid problem solved. I also want to appologize for all my many mistake and bad written. I am not good in english cause I live in Montreal and my first l...
First of all I would like to say HI to everyone here ! and I hope I can get my little stupid problem solved. I also want to appologize for all my many mistake and bad written. I am not good in english cause I live in Montreal and my first l...
answer(3) view(424) status()
)
Query help: Missing right parenthesis
My query Code: SELECT node_nme, os_nme, os_vrsn_nme, CPU_QTY, mch_id_nme FROM node_t WHERE node_nme IN ( SELECT DISTINCT upper(node_nme) as node_nme FROM node_t WHERE row_status_cde IN (1,4) AND node_nme NOT IN (SELECT D...
My query Code: SELECT node_nme, os_nme, os_vrsn_nme, CPU_QTY, mch_id_nme FROM node_t WHERE node_nme IN ( SELECT DISTINCT upper(node_nme) as node_nme FROM node_t WHERE row_status_cde IN (1,4) AND node_nme NOT IN (SELECT D...
answer(1) view(623) status()
)
Oracle 9i Default Username and Password
Well i am a student. I Just got Oracle 9i installed. But can not login . What are the Default username and password for "Oracle9i Discoverer Administrator" and other Develpers Suite apps? Also What URL should i type to acce...
Well i am a student. I Just got Oracle 9i installed. But can not login . What are the Default username and password for "Oracle9i Discoverer Administrator" and other Develpers Suite apps? Also What URL should i type to acce...
answer(1) view(396) status()
)
sqplus arrows
Hey, can someone give me a clue how to define the arrow keys for work in sqlplus just as they do in a regular xterm?. History key function is not an issue now. So far I made the backspace work with it. using: Oracle 8i sqlplus in xter...
Hey, can someone give me a clue how to define the arrow keys for work in sqlplus just as they do in a regular xterm?. History key function is not an issue now. So far I made the backspace work with it. using: Oracle 8i sqlplus in xter...
answer(4) view(820) status()
)
How to resotre Initialization Parameters
Hi all, I modified some of the initialization parameters of a particular instance in the oracle server. I logged in to the oracle instance using the Instance Manager, and changed some of the initialization parameters. When I tried to app...
Hi all, I modified some of the initialization parameters of a particular instance in the oracle server. I logged in to the oracle instance using the Instance Manager, and changed some of the initialization parameters. When I tried to app...
answer(1) view(72) status()
)
connecting through a router
Dear sirs: I have installed Oracle 9i in a W2K server, and I can acces it from any workstation in the LAN (by installing Oracle Client). I cannot understand why I am not able to connect from an "external" PC with the same Cl...
Dear sirs: I have installed Oracle 9i in a W2K server, and I can acces it from any workstation in the LAN (by installing Oracle Client). I cannot understand why I am not able to connect from an "external" PC with the same Cl...
answer(4) view(628) status()
)
DeadLock issue in Oracle
Hi, I am running Oracle 8.0.5.0.0 on a Linux machine and I am executing bunch of procedures and functions written in PL/SQL. I was trying to re-load one of the procedures called if_proc I got a message saying that there is a dealock. ...
Hi, I am running Oracle 8.0.5.0.0 on a Linux machine and I am executing bunch of procedures and functions written in PL/SQL. I was trying to re-load one of the procedures called if_proc I got a message saying that there is a dealock. ...
answer(0) view(458) status()
)
FRM-50016: Oracle Forms
In Oracle Forms6i I Have a Item which is Number Datatype. When i Enter Characters it is saying the following error Can anyone help me how to write function for this FRM-50016: Legal characters are 0-9-+E. That is it says us to ent...
In Oracle Forms6i I Have a Item which is Number Datatype. When i Enter Characters it is saying the following error Can anyone help me how to write function for this FRM-50016: Legal characters are 0-9-+E. That is it says us to ent...
answer(0) view(510) status()
)
problem on Linux installation of oracle.
Hi all, I need help on installation of Oracle 9i on RedHat 9. I want everything install under /home/oracle just for learning purpose. I finished setup users and groups and ran "runInstaller", the wizard went all the way thro...
Hi all, I need help on installation of Oracle 9i on RedHat 9. I want everything install under /home/oracle just for learning purpose. I finished setup users and groups and ran "runInstaller", the wizard went all the way thro...
answer(0) view(883) status()
)
Oracle report print with word
Hi, I want attach/include a word document in Oracle Reports6i, so that when I run the report, it displays/ prints all the pages of the word document. Currently when I attach a word file using OLE2 file type, it displays only the first pa...
Hi, I want attach/include a word document in Oracle Reports6i, so that when I run the report, it displays/ prints all the pages of the word document. Currently when I attach a word file using OLE2 file type, it displays only the first pa...
answer(1) view(525) status()
)
Ref Cursor
Hi, I have written this code,, create or replace package kit_admin as TYPE PackRec IS RECORD (pack_cd VARCHAR2(5)); TYPE crsr IS REF CURSOR RETURN PackRec; procedure selectPackages(V_crsr OUT crsr); end kit_admin; This packa...
Hi, I have written this code,, create or replace package kit_admin as TYPE PackRec IS RECORD (pack_cd VARCHAR2(5)); TYPE crsr IS REF CURSOR RETURN PackRec; procedure selectPackages(V_crsr OUT crsr); end kit_admin; This packa...
answer(2) view(661) status()
)
Problem with oracle query via Java
I'm trying to run this query in java (connected via jdbc) and I get the ORA-00936 missing expression error. Code: Query: sSQL = "INSERT INTO jn_db_user_t (db_id, user_id, user_typ_cde, row_crt_dte, row_upd_dte, row_dlet_in...
I'm trying to run this query in java (connected via jdbc) and I get the ORA-00936 missing expression error. Code: Query: sSQL = "INSERT INTO jn_db_user_t (db_id, user_id, user_typ_cde, row_crt_dte, row_upd_dte, row_dlet_in...
answer(2) view(264) status()
)
email validation in pl/sql
i know that pl/sql's strong point is not regular expressions, and i'm well aware of better solutions to do this. given my requirements per employer, email validation will need to be done in the pl/sql layer. i'd like to implement RFC822...
i know that pl/sql's strong point is not regular expressions, and i'm well aware of better solutions to do this. given my requirements per employer, email validation will need to be done in the pl/sql layer. i'd like to implement RFC822...
answer(6) view(185) status()
)
Which language are you using w/ Oracle?
I'm a PHP / Java web applications developer working for a large NPO. Currently we use MySQL as our primary database for web applications, in conjunction with PHP. Our customer information is stored on an AS400 midrange which runs IBM's...
I'm a PHP / Java web applications developer working for a large NPO. Currently we use MySQL as our primary database for web applications, in conjunction with PHP. Our customer information is stored on an AS400 midrange which runs IBM's...
answer(2) view(700) status()
)
Oracle Personal Edition for Linux
Hello, Anyone konws if there is a personal edition of Oracle DB for linux? I need a copy for school project. Thanks
Hello, Anyone konws if there is a personal edition of Oracle DB for linux? I need a copy for school project. Thanks
answer(1) view(986) status()
)
SQL query Help Needed.
Hi All, I am writing a checker that should hit all the views one after other in database and report if there is an SQL error ( Page: Data cannot be retrived from the view XYZ). The query I am running is "select * from $view ...
Hi All, I am writing a checker that should hit all the views one after other in database and report if there is an SQL error ( Page: Data cannot be retrived from the view XYZ). The query I am running is "select * from $view ...
answer(3) view(298) status()
)
Join Counting, please anyone help!
I have two tabels: Column Name Data Type StudentID NUMBER(5,0) NOT NULL Name VARCHAR2(25) Major VARCHAR2(15) GPA NUMBER(6,3) Column Name Data Type StudentID ...
I have two tabels: Column Name Data Type StudentID NUMBER(5,0) NOT NULL Name VARCHAR2(25) Major VARCHAR2(15) GPA NUMBER(6,3) Column Name Data Type StudentID ...
answer(7) view(924) status()
)
extracting .dmp files
ok, i've searched a lot, and i couldn't find a solution for my problem... i have a backup of the database in .dmp format and i need to partially restore it (there were some deletions by mistake in it and i need to restore some part of th...
ok, i've searched a lot, and i couldn't find a solution for my problem... i have a backup of the database in .dmp format and i need to partially restore it (there were some deletions by mistake in it and i need to restore some part of th...
answer(2) view(770) status()
)
tablespace
sorry.. I hit new post instead of reply. Please see see http://forums.devshed.com/showthrea...0464#post380464 instead.
sorry.. I hit new post instead of reply. Please see see http://forums.devshed.com/showthrea...0464#post380464 instead.
answer(0) view(174) status()
)
Problems...Can't Install... Help needed
Hi first time I installed Oracle9i i hadn't any problem... Then i deinstalled oracle Today i wanted to reinstall oracle9i again and i can install it anymore.... Always getting some weird messages.....Starts with setting up the path......
Hi first time I installed Oracle9i i hadn't any problem... Then i deinstalled oracle Today i wanted to reinstall oracle9i again and i can install it anymore.... Always getting some weird messages.....Starts with setting up the path......
answer(2) view(279) status()
)
Programming
- PHP Development
- Perl Programming
- C Programming
- Java Help
- Python Programming
- ASP Programming
- .Net Development
- Visual Basic Programming
- XML Programming
- WAP Programming
- HTML Programming
- JavaScript Development
- CSS Help
- Flash Help
- Photoshop Help
- Web Design Help
- Database Management
- MySQL Help
- MS SQL Development
- Oracle Development
- Mail Server Help
- Apache Development
- DNS
- IIS
- Networking Help
- FTP Help
Related Pages
- sql query 'group by' error
- FORMS_DDL (INSERT) dosent work
- Select Data between dates
- View Limitations
- pl-sql query error
- create view error !! (missing parenthesis error)
- Removing Illegal Characters???
- PL/SQL Package error
- Business days
- Oracle Blobs stored in Access
- Aliases in SQL
- Heelp!! Problems with dates
- Data Migration..need help!!!!
- Help Oracle character functions
- How to find Oracle client version # in *nix?
- Oracle PL/SQL help
- Question on: &
- Oracle xe INSERT
- view all tables in another schema?
- find all table names with a given value for a given column
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2010 by Infoqu. All rights reserved
Copyright 2007-2010 by Infoqu. All rights reserved