SQL & PL/SQL :: Save Point Is Not Working?

Dec 20, 2011

In oracle 9i, I have a table and i inserted the more then 3 records and while inserting each records i have created the save point. But, now i rollback to that particular save point, the whole transaction get roll backed.

Here the similar example what i have tried using SQL Developer Eg:

insert into dept (deptid,dept_name) values (3,'Purchase');
savepoint aa;
insert into dept (deptid,dept_name) values (4,'IT');
savepoint bb;
insert into dept (deptid,dept_name) values (5,'System');
savepoint cc;
rollback to bb;

View 10 Replies


ADVERTISEMENT

Forms :: Loop Is Not Working Properly - Cannot Save All Records

Oct 11, 2010

here i m giving the code

DECLARE
TYPE SUBNO_TABLE_TYPE IS TABLE OF
TRANS_DEICMAIN1.SUBNO%TYPE
INDEX BY BINARY_INTEGER;
SUBNO_TABLE SUBNO_TABLE_TYPE;
K NUMBER := 1;
S NUMBER := 1;
[code]...

HERE CHECK1 IS A CHECKBOX.WHEN I AM USING THIS CODE ONLY ONE RECORD IS SAVED AT A TIME INSTEAD OF SAVING ALL RECORDS.

View 2 Replies View Related

ORA-00932 - Sample Code Working Fine In 10g And Not Working Now In 11g

Apr 1, 2013

Below is the sample code working fine in 10g and not working now in 11g.

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "PSTest" AS
import java.sql.SQLData;
import java.sql.SQLException;
import java.sql.SQLInput;
import java.sql.SQLOutput;
import java.util.List;
[code]....

we got the below error: ORA-00932: inconsistent datatypes: expected an IN argument at position 1 that is an instance of an Oracle type convertible to an instance of a user defined Java class got an Oracle type that could not be converted to a java class

Current Oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit and the version we are upgrading is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

View 3 Replies View Related

PL/SQL :: To_char Not Working / (||) Is Working With Join Query

Mar 22, 2013

I have two tables : oa_membership_dtl(in this created_by field is varchar2(200 byte) ,oa_partner_usr_dtl(in this table partner_userid is number(8,0) i need to do join on above fields.

I am using following two queries:

select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on to_char(partner_user.partner_userid,'9999')=membership.created_by
select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on rtrim(ltrim(partner_user.partner_userid||' '))=rtrim(ltrim(membership.created_by))

by using first data is not fetched but 2nd is working fine , i am getting the matched records using 2nd query.

whats the diff between to_char and || symbol?

View 1 Replies View Related

Fix Number Of Digit After Decimal Point?

Mar 21, 2007

I have a small prob. I want an amount to be always 2 decimal places. I've used the Round function - Round(amount,2). the problem is that if the amount is only to 1 dp like 1.4. the above function will return 1.4. I want it to appear like 1.40

View 2 Replies View Related

Spatial :: Extract Point Heights From TIN?

Jun 18, 2013

Like to know a easy method to extract height for a coordinate in the TIN.

View 0 Replies View Related

PL/SQL :: Find ALL Objects That Point To One Column

Oct 15, 2012

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE     11.2.0.3.0     Production
TNS for Solaris: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

I have multiple schemas, all which have tons of objects that point to one column of one table. I tried to look at v$sqltext, and v$sqlarea, but it doesn't seem to show as expected.

Is there a view that I can look at that will show me all the objects that relate to one column?

my situation. Had to change the data structure of this one column. Changed the default value from a Y to an L. I have packages, functions, triggers...etc... that deal with this one column. I need to ensure that I go through EACH one and edit them to reflect the change to the table column. And again, this spans multiple schemas that point back to it.

View 5 Replies View Related

Maximum Of VALUE Field Of Each Record With Different POINT-NUMBER?

Oct 21, 2011

I need to get the maximum value of the VALUE field of each record with different POINTNUMBER, then do an update on the 2nd table.

table 1
UTCTime TIMESTAMP (6)
INTEGER POINTNUMBER
FLOAT VALUE (126)
INTEGER TLQ

table 2 (idem structure)
UTCTime TIMESTAMP (6)
INTEGER POINTNUMBER
FLOAT VALUE (126)
INTEGER TLQ

Where POINTNUMBER is six thousand different values My query only returns me the maximum of a single record:

SELECT * FROM table1 WHERE value = (SELECT MAX (value) FROM table2);

And the update:
UPDATE table2 SET to a.value = (SELECT MAX (b.value) FROM table2 b);

so does on a single record.That needed to maximize each pointnumber different? I can use a cursor to do this easier?

Insertion should first make a one-time, and then updates every 1 hour

View 1 Replies View Related

SQL & PL/SQL :: Selecting Numbers That Has Only 3 Digits After Decimal Point?

Mar 10, 2011

How to write SQL query for selecting all the values (numbers) in the table which has 3 digit after decimal point.

For example say A is the table it has following values

200.24
300.456
123.22
1234.344

From this I need only

300.456
1234.344

View 14 Replies View Related

SQL & PL/SQL :: Function That Multiply Number When There Is More Than 3 Decimal Point?

Mar 20, 2010

how to create a function that will multiply the number when the number has more than 3 decimal point.

Example.
123.012 - multiply by 10
123.0123 - multiply by 100
123.01234 - miltiply by 1000

Column A is the result of the number being multiplied according to decimal point.
Column B contains the multiplier used in column A.

View 10 Replies View Related

RMAN Tablespace Point-in-time-recovery

Mar 25, 2013

I need to recover a tablespace called "SBSECD01_MDS" (point-in-time).I need to determine and resolve dependencies.

select obj1_owner, obj1_name, obj1_type, ts1_name, ts2_name from sys.ts_pitr_check where (ts1_name = 'SBSECD01_MDS' and ts2_name != 'SBSECD01_MDS') or (ts1_name != 'SBSECD01_MDS' and ts2_name = 'SBSECD01_MDS');

own1 name1 obj1type ts1_name ts2_name
--------------- -------------------- -------- ------------------------------ --------------------
SBSECD01_MDS MDS_PATHS_N7 INDEX SBSECD01_MDS -1

so I can see index SBSECD01_MDS.MDS_PATHS_N7 's ts2_name is "-1".reason: Domain/Functional Indexes not supported...My question,

1, what means ts2_name?

2. what means "-1"? (it looks not like a tablespace name)

3. in this case, Can I perform a successful TSPITR?

If not, how can do to make a successful TSPITR? (do I need to drop that index first, then recreate it after recovery?)

View 1 Replies View Related

Spatial :: Select Attributes In Point Cloud

Oct 10, 2012

I have data in point cloud (x,y,z,a,b,c,d (a,b,c,d are some attributes about this point)). i create a point cloud (sdo_pc - geometry), block tables (sdo_geometry - geometry). if i use a function to_geometry, result is only in multi point without attributes. it is way display this 3D data, and at the same time inquire of concerning for a attributes in concrete points?

View 0 Replies View Related

RMAN :: Point In Time Recovery Using Restore?

Aug 30, 2012

Oracle RDBMS 11.2.0.2.RAC and Host RHEL 5.6

My dev application team iwant to test their application, and once that is done they want to recover to point in time. In my case they would do that after 9.0Am and once that is done they want the state of the database back to 9.0Am

What i am planning to do is:create a restore point at 9.0Am and once application testing is done recover until restore point. ..But i was suggested not to do that way instead my Lead want me to use just recover until timestampI asked what is the difference in doing in my way,the answer i got is by using recover until restore point, the recover process cannot apply incremental level 1 backups and it just restores to a point of incremental level 0, it looked strange to me.

View 3 Replies View Related

Spatial :: How To Get All The Values Of The SDO_ORDINATE_ARRAY Of A Oriented Point

Dec 14, 2012

I'm trying to get the values of a Geometry which is an Oriented Point. To that, i'm using SDO_UTIL.GETVERTICES, but this utility only obtains the point X,Y, it doesn't obtain the values of the orientation vector.

The Geometry is this:
MDSYS.SDO_GEOMETRY(
2001,8307,NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1,1,1,3,1,0),
MDSYS.SDO_ORDINATE_ARRAY(-75.586088632813272,6.1794352615514194,0.57278169530235967,-0.81970795380217887,0)
)

The query is this:
SELECT c.ipid, c.nombre, t.X, t.Y, t.Z, t.W
FROM Hidrantes c,
TABLE(SDO_UTIL.GETVERTICES(c.geometria)) t
where c.ipid = 4691117
ORDER BY c.ipid, t.id;

Result:
4691117          -75,5860886328133     6,17943526155142          (null) (null)

As you can see, it only obtains the X,Y values but not the values of the orientation vector, how can I get the values?

View 2 Replies View Related

Client Tools :: How To Print A Floating Point Value

Aug 5, 2010

I use SQL Developer. I cannot select/print any floating point values.

My script:
variable xx NUMBER;

declare
x number;
begin
x := 1.5;
:xx := x;
end;
.
run;

PRINT :xx;
Output:
anonymous block completed
xx
-
1
What is the problem? How can print a floating-point value?

View 7 Replies View Related

RMAN BACKUP ACFS Mount Point That Are Used For DBHOME?

Oct 24, 2012

We are Using ACFS File system for DBHOME and its Called "/u01/app/oracle". I would like to know, can i use RMAN to backup my oracle home?

View 4 Replies View Related

Forms :: Calling Report - Entry Point Not Found

Jun 7, 2010

declare
v_show_documentVARCHAR2 (2000) := '/reports/rwservlet?';
v_connectVARCHAR2 (200) := 'userid=scot/tiger@connect_string';
v_report_serverVARCHAR2 (30) := 'rep_cs-oracle';
-- i make this server name by using this command:C:DevSuiteHome_1BIN
wserver server=rep60 start >>when i started it getting to shutdowing directly!!!!! i don't know why
[code].....

the error is:

before the browser is opened!! an error is occur is that:
javaw.exe -Entry point Not found
the procedure entry point kguuseg could not be located in the dynamic link library oraclient10.dll

then the browser is opened ,this error written in it:

REP-52266: The in-process Reports Server rep_cs-oracle failed to start.org.omg.CORBA.OBJECT_NOT_EXIST: vmcid: SUN minor 204 completed: No

View 2 Replies View Related

RMAN :: ORA-01516 With Tablespace Point-in-time Recovery

Jul 29, 2012

Oracle 11.2.0.1.0 on CentOS 5.5

i am now facing Tablespace Point-in-time subject. Doing some tests, the following problem appeared:

sql statement: alter database datafile  1 online
sql statement: alter database datafile  3 online
sql statement: alter database datafile  2 online
sql statement: alter database datafile  10 online
[code]....

ORA-01516: nonexistent log file, data file, or temporary file "10"I am using the following command to restore one of my tablespaces:

RMAN> run {
2> recover tablespace tbs_testes_pitr until time "to_date('25/07/2012 19:50:00','dd/mm/yyyy hh24:mi:ss')"
3> auxiliary destination '+DATA';
4> }The error described at the begin of this thread only appears at the end of the operation. I did some research, and the error ORA-01516 indicates that the datafile is not known by the database. When this error appears, i have to do a media recovery on datafile 10, which in fact exists, and is the datafile atached to the tablespace that i am trying to recover

View 6 Replies View Related

PL/SQL :: Regular Expression To Check Number With At Least One Decimal Point?

Nov 18, 2013

I would like to use the REGEX_LIKE to check a number with up to two digits and at least one decimal point: Ex.10.11.1112 This is what I have so far.

if regexp_like(v_expr, '^(d{0,2})+(.[0-9]{1})?$') t

View 3 Replies View Related

RMAN :: Ways To Restore Database To Point Time

Feb 21, 2013

i have oracle 11gr2 database on linux 5.5

i have the performed level 0 rman backup on 15th feb 2013, and after that i have incremental 1 and archives and controlfile backup. Before this no backup is the database.

Now i want to restore it to 12th feb 2013.so is there any ways to restore the database to that point time.can we restore controlfile to point in time.

View 5 Replies View Related

Spatial :: Sdo_nn To Fetch Points From Point Cloud And Georaster

Mar 9, 2013

I have a requirement to fetch the nearest neighbor from a given point coordinates inside a point cloud/georaster data. how can i retrieve a collection of all neighboring points from a given point.

I guess i will have to use sdo_nn operator. how to use the operator to achieve the result.

View 21 Replies View Related

PL/SQL :: Round Function Output Depend On 2nd Digit After Decimal Point

Oct 19, 2012

I have a question on Round Function

Round(###.###,1)

Will the round function output depend on 2nd digit after decimal point also or not?

View 6 Replies View Related

Real Application Clusters :: Best Option 10g Or Oracle 11g RAC For Certification Point?

Oct 5, 2012

which one is best option RAC 10g or oracle 11g RAC for certifiction point of view?can any one detail difference between above 2 options?

View 4 Replies View Related

Enterprise Manager :: Null Point Error On Charts Of Host CPU And On Active Ses

Oct 17, 2012

i am getting error when iam starting enterprise manager GUI dbcosole,its not displaying the graphs of HOST CPU and active session graphs instaed its giving me error such as java.lang error and null point error below the graphs.

i stop and start the dbconsole from services and from command prompt and rebooted the server,but still showing the same error..did open in other kernals such as mozilla and google still the same issue..

View 3 Replies View Related

Application Express :: How To Pass Parameter / Create New Region / Set Display Point

May 3, 2013

On package application "Customer Tracking", there is good example about Modal Page. Quite simple but it work quite nicely.The step to create this Modal Page:

- Create new region, set display point: After Header and use region template: Modal Region and set the Static ID (eg. ActivityModal)
- Create the page item and put it on the above region (eyample: Name, Company etc.)
- Create a button, set the action to "Redirect to URL" and enter the URL target to: javascript:openModal('ActivityModal');

Now when you click on the button, the modal page will be display.How can I pass a parameter to the modal page, example: I want to pass text 'Johnny' to the Name page item which is on the modal region.

View 2 Replies View Related

Recovery Manager (RMAN) :: To Restore 11gr2 Database To Point In Time

Dec 15, 2012

I am trying to restore 11gr2 database to point in time. using following steps:

Control files are fine, that are not restored.

RMAN> run
{
set until time "to_time('2012-12-13 12:12:00','YYYY-MM-DD HH24:MI:SS')";
}
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open;

Here my problem is it is restore complete data what ever i was having, but i don't was it, i has to restore up to specified time only.

View 2 Replies View Related

Real Application Clusters :: Check Archive Mount Point Size From Sqlplus Prompt?

Feb 15, 2013

I am in need to find archive log mount point space detail usage through sqlplus on multiple instance. Is there any view in oracle which can give me the detail.

I know one method using external table but that is cumbersome for RAC.

can i get some command like this.

select inst_id,mountpoint,space_usage,space_available,total from GV$table --> returns

View 4 Replies View Related

RMAN :: Restore Point Backup And Restore To New Host

Mar 14, 2013

We want to keep the Guaranteed restore point for week but unfortunately we don't have enough flash space in the server. Is it possible to backup the flashback log(restore point logs) through rman and send bkp file to tape? how to restore the database in new server until Guaranteed restore point.

View 1 Replies View Related

Forms :: Do You Want To Save Record

Aug 22, 2005

I have created a form which as two block as master and detail.I am facing two problem in my detail block.

First: When I populate records in detail block, it prompt a message 'Do you want to save record ?'.
Second : When I alter any value in detail block and move to next record, it prompt a message 'Do you want to save record ?'

Is there any way where, system don't prompt me a message for saving record and user can continue with changes and save the records when he desire.

View 16 Replies View Related

SQL & PL/SQL :: Image Save From Java GUI

Apr 5, 2011

I am currently working on project which is basically development is going on Java Spring and Oracle 10g

I have a problem when i am calling the procedure from Java GUI

I am created directory named IMAGE_DIR

CREATE OR REPLACE PROCEDURE u_rfnd_cnd_test
(ackno in varchar2, p_name IN u_rfnd_cnd_petition.URCP_IMAGE_NM%TYPE) IS
v_bfile BFILE;
v_blob BLOB;
BEGIN
INSERT INTO u_rfnd_cnd_petition (URCP_ACK_NO, URCP_IMAGE_NM, URCP_IMAGE)
VALUES ( ackno,p_name, empty_blob())
RETURN URCP_IMAGE INTO v_blob;

[Code]..

When i m calling this procedure from Oracle itself its working fine

But when calling this procedure from Java GUI with same parameter then i am getting error

But still i am getting an error saying.

Error :java.sql.SQLException: ORA-22288: file or LOB operation FILEOPEN failed The system cannot find the path specified. ORA-06512: at "WBCOMTAX.U_RFND_CND_TEST", line 18

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved