• 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...

    Ceepari0 pointsBadges:
  • Simple but not so

    I have 2 table 1) Product_Inf and 2) Product_attribute_details I have prod_key, dye_class, prod_range in both the table. Their is no relation exist between both the table than how can i find the records available in Product_Inf but not in Product_attribute_details?

    Ilink880 pointsBadges:
  • CLOB and VARCHAR2

    Hi Isn't there a mid way between using the VARCHAR2 and CLOB datatypes? I need to have a column that will contains upto 6000 characters so I can not use VARCHAR2 for this. And i don't want to use CLOB as it might bring in some other problems like space management (coz it can occupy upto 4gb)....

    Abhivyakti0 pointsBadges:
  • Installing Oracle 9i on Windows XP

    When trying to install Oracle 9.2 on a computer that has Windows Xp, I am receiving this error message: Unable to install Orcale 9i: EDS cannot support more than two Oracle homes. Then the installation aborts. How can I fix this problem?

    Bushka0 pointsBadges:
  • Changing Server Name Where ORACLE is Loaded

    I was wondering other than to edit the TNS names, would changing the server name andor the IP address where ORACLE is loaded and the data files are located, what other parameters or files do I need to changeedit? Is this doable without too much work? Many thanks, Sam

    SamAvella30 pointsBadges:
  • SECURE FTP SITE ON Windows 2003

    We have a Windows 2003 IIS server setup behind our firewarll which is a PIX firewall. What is the best method to establish a secure FTP site on this IIS server? I have reviewed this topic on the internet and actually talked with somebody from IPSWITCH and the best method available is to purchase a...

    Mconfer0 pointsBadges:
  • 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 Don?t assume...

    Sairam170 pointsBadges:
  • problem in installing the second oracle home

    Hi all, Iam having problem in installing the second Oracle_Home to install my SAP Test server , iam already having one Oracle_Home configured which is for my development server on the same box which should not be disturbed. In the Oracle Universal Installer iam giving the Oralce_Home and the path...

    Basis50 pointsBadges:
  • need help in vb code

    Good day, Iam traying to get result of my record as below If next record is biger than previous show "1" If next record is same previous show "1" If next record is smallest show "0" if next record is same previous show "0" Example [CODE] id Time Code Price Res 1 10:00:00 AM 1010 905...

    Rosy990 pointsBadges:
  • Microsoft Access Query Question

    I have created a Database that will create a Resume from Data entered. What I am having problems with are in a Query I have created named "PapersPresented" I have several Authors for One Paper. I want to combine the multiple Authors for each paper so as to eliminate the data redundancy and make it...

    Boggy10 pointsBadges:
  • limit of IN subquery

    what is a limit to use literal values as subquery in IN caluse.

    Vajeem0 pointsBadges:
  • ORA-0942 Table or View Does not exists

    Hello there, I have been running into this error when I create a View based on embedded view and the Schema User has complete permissions on all the objects in question. The environment is Oracle 9i [9.2.0.4.0]. The one thing that distinguishes this view from any other view is that there...

    KALKAJI0 pointsBadges:
  • Visual Basic

    What is the difference between VBA and Visual Basic.Net...I want to learn how to write scripts to automate certain tasks.

    Idapsdst0 pointsBadges:
  • 10G Database Restore to New Server from Backup

    I am a Sr. SQL Server DBA but brand new to Oracle. I have been given a task by my management to perform a backup from our production server and restore it on a brand new server to simulate a disaster. Our environment is Windows 2003 Server and Oracle 10g database. I am having allot of difficulty...

    Sqldatapro0 pointsBadges:
  • ORACLE NOT RECOGNIZING NEW RAM

    We installed more memory on our Windows Enterprise Server but Oracle does not recognize the new memory. I know this because when I select ?host? from Enterprise Manager?s home page the host memory is listed as 2g and it should be 6g. If I try to use the new memory by increasing the sga_max_size...

    Emersokl0 pointsBadges:
  • pl/sql ref cursor question

    Hi, I'm trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1. Obtain a...

    Ajhaveri0 pointsBadges:
  • Automatically Populating a Date Field in a Table

    Can you please forward me an example of a trigger or some other means on how I can update a date field (e.g., DATE_COMPLETED) in a table when another field (e.g., EDITS_COMPLETED) within that same table has been populate with a particular value (YES)

    SamAvella30 pointsBadges:
  • Using LIKE with Variable Value not Literal Value….INSTR not optional

    I'm trying to build a search type select statement constrained by a users input.....variable(x) which forces the use of like in the selection processing: x := (whatever user enters); I have tried with no luck: Select * from personnel where lastname like '%x%'; Select * from personnel where lastname...

    BAdams20 pointsBadges:
  • ora-12154

    I'm new to Oracle so forgive me if I don't have all the terminology down, but I've installed Oracle 10g and I'm constantly getting an "ora-12154 Could not resolve the connect identifier" error at step 12 in database configuration assistant. I beleive it has something to do with the tnsnames.ora...

    Wilson630 pointsBadges:
  • Oracle Application or Database on its own server.

    Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be...

    Ktharrell0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following