Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we’re using now for the server B the alias we’ve used for [...]

Answer Question   |  November 1, 2006  11:28 AM
Architecture/Design, Backup & recovery, Data/Application Integration, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, SQL, Tech support, Windows

help! – - – trigger compilation error when calling a stored procedure.
my trigger wont compile. below is the code and errors. Any help is greatly welcomed. thanks very much. DECLARE ROWCNT NUMBER; PIN NUMBER; SIGNUP_URL VARCHAR; – – BEGIN SIGNUP_URL := ‘http://signup.2gn.com/signup.pl’; SELECT COUNT(*) INTO ROWCNT FROM SUBSSHORTCODE WHERE SHORT_CODE = :N.SHORT_CODE AND SUBSCRIBER_PHONE= :N.SUBSCRIBER_PHONE; IF rowcnt >0 THEN UPDATE MSGLOG SET STATUS = ‘A’ WHERE [...]

Answer Question   |  October 7, 2006  10:01 AM
Oracle development

please solve this query
Create Emp table containing an Empno column with the following sample data:- EMP ——- EMPNO ———– 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ———— 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 [...]

Answer Question   |  September 5, 2006  4:04 AM
Database, DB2, Oracle, Oracle development, SQL

HELP : I retrieve a blank page with UTL_HTTP in a request to a server which listen in a different Port than 80
Dear colleagues I have a problem because a developer form our team, has a problem to retrieve a webpage in Oracle Portal whit UTL_HTTP. If he attempts to retrieve a webpage (pending to Oracle Portal) by a PACKAGE whit the next sentence: URL_TABLE := utl_http.request_pieces(p_website, 99999, ‘<server.domain.com>:7778′) he received a blank page. If he attempts [...]

Answer Question   |  July 12, 2006  1:44 PM
Oracle 9i, Oracle development

Running a script at specified runtime
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks

Answer Question   |  July 11, 2006  12:23 PM
Architecture/Design, Availability, Backup & recovery, Business Intelligence, Data/Application Integration, E-Business Suite, Installation, Migration, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows

Oracle Reference to Table_Name, Column_Name, etc by reference to variable
Does Oracle prohibit reference to Table_Name, Column_Name, etc by reference to a declared variable? I am trying to create a simple routine to print documentation whenever any changes are made to the database using the following routine: DECLARE CURSOR Table_cursor is SELECT * FROM TABS WHERE table_name like upper(‘c%’) or table_name like upper(‘t%’) or table_name [...]

Answer Question   |  September 16, 2008  3:15 PM
Oracle, Oracle 8i, Oracle development, SQL

Oracle ODBC Drivers from Oracle vs. Microsoft
I am wrestling with whether Microsoft products (e.g., Excel-MS Query) that use ODBC to access Oracle databases would benefit more by using the latest driver from Oracle or Microsoft. If using a driver from Microsoft, is it likely to be significantly less efficient in exploiting the latest features of the Oracle database (which continues to [...]

Answer Question   |  May 4, 2006  7:11 PM
Development, Oracle development, VB.NET, Visual Basic

inserts through a database link
Hello every body. Here I go again… Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to the second [...]

Answer Question   |  March 31, 2006  10:13 AM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Installation, Migration, Oracle, Oracle 8i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows, XML

Difference between length and vsize functions
Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik

Answer Question   |  March 29, 2006  3:34 AM
7 and earlier, Database, DB2, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, Oracle development, SQL

Configuring isql *plus
Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik

Answer Question   |  April 18, 2006  3:21 AM
Database, DB2, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, Oracle development, Oracle Manufacturing, SQL, Windows

Using optimizer hints in Forms
Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look [...]

Answer Question   |  March 28, 2006  12:28 PM
Oracle, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle development, Performance/Tuning, Security, SQL