[oracle] Forum Topics

hi james cherril I am doing a voting system application of which I have to hand up today. I am getting a runtime error when I entered a record and try to save it. as I entered one record and when the save button is pressed it give me a …

Hi All, I am working on Oracle 11.2.0.3. and my requirement is, I have a table in Development(Dev) called " Dev_EMP". Have created Synosym for "Dev_EMP" as "SY_DEV_EMP" here is the structure [/code] create table Local_emp ( tran_id varchar2(10), acct_id varchar2(15) ); [/code] 2. Table which I am planning to …

Hi, I'm having CLI0100E Wrong number of parameters. SQLSTATE=07001 exception when I try to [code] private void PopulateTable() { bool IsConnecting = true; while (IsConnecting) { try { cn = null; cn = new OleDbConnection(strConn); cn.Open(); sSqlCommand = "select a.sicil_no ,a.adi||' '||a.soyadi as isim,b.unvan_aciklama,a.ilkgir_tarihi,a.ayrilma_tarihi,a.sua,a.dogum_tarihi " + "from per015_ssk a,per003_ssk b"; …

Hi, I am currently working on Oracle 11.2.0.3. Below is my requirement. 1.I would like to scan the database ( Eg. 1 entire schema) and need to find the DB object either Procedure/Funcation which is having DROP statement. ( some of the procedures having " DROP PROCEDURE <PROCEDURE_NAME> " statements. …

Hey!! i am using php to delete data from database but its not deleting and no error is showing. Please help me. <?php include('connect.php'); $p_No = $_POST['p_No']; $sql2 = "DELETE FROM usersR WHERE p_No = '$p_No'"; $compiled1 = oci_parse($conn,$sql2); $ex = oci_execute($compiled1,OCI_DEFAULT); ?>

CREATE TABLE BUILDING(bname VarChar2(30) PRIMARY KEY, address VarChar2(30), phone number Number(15)); i write this code in sql command of oracle application express. but there is a error ORA-00907: missing right parenthesis anyone help me please i am new in oracle world

How to open and view the folder from my computer using plsql?

I have been butting my head against this problem for the past 4 hours, and I have to tap out. I know I can't be too far from correct I am just not sure what the missing ingredients are. Here is the problem question: Student status: List of all students …

Hi, I'm starting to learn Java EE - JSP / SERVLET and as for my learning progress, I'm trying to achieve this kind of web app but Im having problem with displaying the right selected row (TASK ID Column) from my table. It is populated from my oracle db. Im …

I am trying to create databases in Ubuntu 14.04 running LibreOffice 4.4.3 and can not due to not connecting with JRE or JDK. Research carried out and things I have tried lead me to understand I need JDK-8 now instead of JRE. Is this accurate? JDK-8 and Java 8 are …

hi guys, anyone can sauggest me which institutes are best to learn oracle in india .

i have this code..,. i dont see what's wrong why its only working on the first record of LOOP of X set serveroutput on size 30000; DECLARE VTEMP NUMBER; VPARENT NUMBER; BEGIN FOR X IN ( SELECT TEMPLATE_ID, TYPE_ID, TYPE_KIND, RECORD_ID FROM RT_RECORDS WHERE TEMPLATE_ID = 106 )LOOP DBMS_OUTPUT.PUT_LINE('TYPE_ID X …

Hi! I have here data: i don't have any idea on how to insert the details in TABLE2... as you can see, the parent_id is based on TABLE1, TABLE 1 TABLE 2 (INSERTED IN NEW TABLE) LEVEL TYPE_TABLE PARENT_NAME RECORD_ID OBJECT_TYPE RECORD_ID PARENT_ID (RECORD_ID FROM TABLE 1) 1 NODEB EQUIPMENT …

i'm trying to find in all tables with data in all columns.. example EMPLOYEE table with ID = 123 COLUMNS DATA ID 1 NAME TEST ADDRESS TESTADDRESS PHONE EMAIL POSITION DEV The output will be ID, NAME, ADDRESS, and POSITION.. so basically all columns with data only.. by the way, …

hi everyone how can I parsing string into token in pl sql? example this is my string "170823-14785" and the parsing I want like this 17 08 23 -1 47 85

hi everyone i am new programer in oracle,i have save the url of the folders in the SQL server and i want to open or select a folder using the saved url by oracle plsql. I have select the url from the database, but the problem i don't know how …

i am a new bee to oracle and database world, i need your help, as i am a student i learnt some commands in class, how to retrieve the tables and its contents in 10g, my question is that, is there any builtin tables in oracle 11g as well if …

My application is developed in visual basic 6 and oracle 11g express is its database. Now we need to make it available on our network for multiple users to use it simultaneously. How can I configure it for the same. What is the procedure to make my application a networked …

I have a project where I have to send data from an Excel spreadsheet to an Oracle database. Here is the code I am using and I need some help. It stops at the second string statement. I am trying to use an Excel range name to Insert or Update …

Im working with Forms Builder. Ive built my form, when Im testing, it shows: FRM-41045::cannot find item:invalid ID. See Help>Online help for details But, online help sucks - there are only unanswered questions (forum-like site) Any help?

Hello, I rebooted my server and it won't startup due to the below error, now server is not getting up, its throwing the below error and keep trying to connect to Oracle, so I am unable to access the server to free some space if its the issue as per …

Need on the best way to going about programming this in c#. I'm trying to do an if record exists update statement else insert statement: OracleConnection con = new OracleConnection(strConnection); con.Open(); OracleCommand check_RID = new OracleCommand("SELECT COUNT(*) FROM CONTRACT_INFO WHERE (rid = @rid)", con); check_RID.Parameters.Add("@rid", labelRID.Text); OracleDataReader reader = check_RID.ExecuteReader(); …

Hi Dw. Long time ago I think late last year my computer was infected and I had installed a VM from Oracle and had a number of OS(VMs) installed one of them was with Win7 but I don't know what happened one day, when I open the VM it was …

/DROP TABLE STATEMENTS/ DROP TABLE BRANCH CASCADE CONSTRAINT PURGE; DROP TABLE SCREEN CASCADE CONSTRAINT PURGE; DROP TABLE SESSIONS CASCADE CONSTRAINT PURGE; DROP TABLE MOVIE CASCADE CONSTRAINT PURGE; /CREATE TABLE STATEMENT/ CREATE TABLE BRANCH( BRANCHID CHAR(2)NOT NULL, BRANCHNAME VARCHAR2(20), BRANCHSUBURB VARCHAR2(15), BRANCHPOSTCODE CHAR(4), CONSTRAINT BRANCH_PK PRIMARY KEY(BRANCHID)); CREATE TABLE SCREEN( SCREENID …

Hi all, I am new in oracle sql dbs and I would like to take some certifications from Oracle. I have just got the 1z0-061: SQL Fundamentals exam, could you please advise me who will be the next ? Is it better to give for PL/SQL or advanced SQL ? …

Hi, I want to delete about 60 crore records from few oracle audit tables to free up some space. I am planning to delete them in batches of size 10,000. I dont want to use up lot of space while performing these deletes. Can someone suggest me a way to …

Iam using windows 7 32 bit and Oracle 11g SQL> spool off SQL> host type c:\spool.txt The system cannot find the file specified. help me to solve the above ploblem

Create Table Non_Game ( P_Id int Not_Null, Item_Num Char(4) Not Null, Description Char(30), On_Hand Decimal(4,0) Category Char(3) Price Decimal(6,2), ))

Group, I've written what I believe is fairly simple code to populate a combobox via data from an Oracle Database. Unfortunately it isn't working and the error in the output box says: "Exception thrown: 'System.BadImageFormatException' in OracleConnections.exe" (the name I've assigned to the program is "OracleConnections"). This is not an …

Hi Group, I'm attempting to pull info from our database to populate a combo-box in VB.net (Visual Studio Express 2015). Here's my first attempt at the connection: Dim conn As New Oracle.DataAccess.Client.OracleConnection() conn.ConnectionString = oraDB From here I'm not sure how to pull the data into the combobox. I do …

Hi group, I've looked all over the internet to find my solution without luck. Hopefully you can help. I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" …

I am working on projects in Visual Studio 2015 using the ASP.Net Identity with Entity framework. Entity Framework creates tables in embedded SQL Compact, when the first user is created. My question is: When comes time to roll out into a "live" environment (i.e. Dev, Test or Prod), is there …

Hello. Allow me to apologize in advance regarding any abnormal phrasing. There is a certain table, hereby dubbed IPT, containing 4 keys and a variety of values. I wish to select several values spread throughout IPT, anchored via the first three keys and a varying fourth. Currently, this is achieved …

Hello, I have to install Oracle Developer 2000 R2.1 on a Windows 8.1 (x64) machine to run an application developed by a third party developer, but my installation keeps on crashing. Tried running in Windows XP SP3 compatibility mode still same result. The error is as follows: "D2KQT10.ins(54): 'Statement' expected …

string query = "DECLARE l_cursor SYS_REFCURSOR;ServiceName la_service_provider_detail.service_name%TYPE;Surname people.surname%TYPE;Forename people.forename%Type;"+ "Action Varchar(50);Rate ey_pupil_premium_log.rate%Type;"+ "Funding_Code single_funding_formulas.funding_code%Type;"+ "BEGIN EYPupilPremiumPackage.GetEyPupilPremiumLog(pLogId=> 6613, pPreview => 'T',EyPupilPremiumLog=> l_cursor);"+ "LOOP"+ "FETCH :l_cursor "+ "INTO ServiceName, Surname, Forename,Action,Rate,Funding_Code;"+ /*IF l_cursor%NOTFOUND"+ Then DBMS_OUTPUT.PUT_lINE('NO DATA FOUND'); EXIT WHEN l_cursor%NOTFOUND; END IF; "END LOOP;"+ "DBMS_OUTPUT.PUT_LINE(ServiceName || ' | ' || Surname || …

Hi I have a procuder which return a recordset using cursor in output what am trying to do is i use cursor to get the data and same have to return it to output cursor .I can do like below PROCEDURE test(value_one IN someTabel.somecolumn%TYPE, valu_two IN someTabel.somecolumn%TYPE, Outputcursor OUT SYS_REFCURSOR) …

sorry for this silly question, i would like to learn ORACLE but i dont know from where should i start and what toopics should be covered? i know sql.so i like to start pl/sql. please suggest me what topics should i cover?

I just use this code to input data to oracle database from vb.net. Try Dim mstream As New System.IO.MemoryStream() PictureBox1.Image.Save(mstream, System.Drawing.Imaging.ImageFormat.Jpeg) Dim arrImage() As Byte = mstream.GetBuffer() mstream.Close() query = "INSERT INTO ds.students (ID,NAME,PIC)" & _ "VALUES (@ID,@NAME,@PIC);" Dim cmd As OracleCommand = New OracleCommand(query, con) cmd.Parameters.Add("@ID", Convert.ToInt32(TextBox1.Text)) cmd.Parameters.Add("@NAME", Convert.ToString(TextBox2.Text)) …

Previously I used vb.net with mysql database and successfully added data from insert query. In that senario my sql code is like this : INSERT INTO ds.students (id, name,pic)" & _ "VALUES (@id,@name,@pic) Now I used oracle database with vb.net. When I run program it shows: "ORA-00936 - Missing Expression" …

heY guys, I just step to oracle database system. so I'm new to this. I'm trying to make connection oracle db with vb.net. I saw below connection string on web. But I dont know it's keywords. So please teach me. SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID))); uid=myUsername;pwd=myPassword;

Hello, I have the below case. CREATE TABLE "PRBT"."TM_TABLE_1" ( "NID" NUMBER, "STRNAME" VARCHAR2(240 BYTE) NOT NULL ENABLE, "NORDERCODE" NUMBER NOT NULL ENABLE, "NSTATEID" NUMBER DEFAULT 1 NOT NULL ENABLE, "STRDETAILS" VARCHAR2(256 BYTE) DEFAULT NULL, "STRAUTHOR" VARCHAR2(128 BYTE) NOT NULL ENABLE, "NPICTUREID" NUMBER DEFAULT NULL, "STRLATINNAME" VARCHAR2(512 BYTE), "STRLATINAUTHOR" VARCHAR2(512 …

Hi team, In hibernate one to many relation ship am updating parent setting with child data when am doing session.update(parent) (parent have set with child data) then am committing the its throwing exception saying that Caused by: java.sql.SQLException: ORA-01407: cannot update ("TPIA"."TPIA_TRANSACTION_DATA"."TRX_ID") to NULL.so please help will get appriciate.

Hello, I'm trying to get this piece of script working, but I'm having an issue on my script. The if [ $DEV_ORA -eq 0 ] is not get run when I run my script. I do not know what I'm doing wrong here. Basically I trying to run the second …

when i save my object in hibernate session.save(obj) getting this exception. (SqlExceptionHelper.java:127) SQL Error: 1747, SQLState: 42000 (SqlExceptionHelper.java:129) ORA-01747: invalid user.table.column, table.column, or column specification (AbstractBatchImpl.java:193) HHH000010: On release of batch it still contained JDBC statements (SessionImpl.java:2994) HHH000346: Error during managed flush [could not execute statement]

I got tired working on that part of code for 3 days and searching on the internet please I need help to know HOW TO use auto complete textbox1 and use its value to set the value of textbox2 and textbox3 below code public class PopulateProduct { public string ProductDesc …

Please explain to me what execution plans and index creation is in Oracle SQL. An example would be great also. Thank you!!

I'm getting this (errorORA-00936: missing expression) when I input this into the sql commands: select || 'The promotion began on the' || to_char(start_date,'ddth')' of 'to_char(start_date,'Month YYYY') from f_promotional_menus where code=110; I tried googling for answers but came up with nothing. Can someone help me figure out what I am doing …

Hello All, I am fairly new to Vb.net. I have experience in MS Access and VBA. I am trying to connect a remote Oracle Database through vb.net but getting the below error. But, the same Oracle database connecting with the help of SQL Developer. Can any one please help me? …

I need to transform between two different database schema the same data. For example i have one table in old schema looking like this: OLD EMPLOYEE TABLE USER_ID - NUMBER (PRIMARY KEY) FIRST_NAME - VARCHAR(50), (NOT NULL) LAST_NAME - VARCHAR(50), (NOT NULL) CITY - VARCHAR(50), (NOT NULL) and i need …

I wan to call oracle database function I tried this but i am getting error `ORA-06550: line 1, column 7: PLS-00221: 'F_GET_DESC' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored` public void Get_Desc() { string oradb = "Data Source=source;User Id=myuser;Password=ss;"; string CommandStr = …