Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table- From and To - BETWEEN operator- View to bring all records between from and to

Rajesh234Jun 28 2019 — edited Jun 28 2019

I have a table  TABLE1 where i have 2 columns ValueFrom and ValTo with SIGN option is BT. Now i need to design a View having one column which constitutes of only column.

TABLE1:

SETNAME SIGN OPTION VALFROM VALTO

ABC            I             BT      500700      500710

VIEW1

COLUMN1

500700

500701

500702

500703

500704

500705

500706

500707

500708

500709

500710

Comments

865505
Here is the hot spot error log.


[ebiz40@DL-CM-TASHA ~]$ cat /home/ebiz40/hs_err_pid30864.log
#
# An unexpected error has been detected by Java Runtime Environment:
#
# SIGBUS (0x7) at pc=0x00002aaaab03f031, pid=30864, tid=1119217984
#
# Java VM: Java HotSpot(TM) 64-Bit Server VM (11.0-b16 mixed mode linux-amd64)
# Problematic frame:
# C [libzip.so+0xb031]
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#

--------------- T H R E A D ---------------

Current thread (0x00002aaac4096c00): JavaThread "TBSU-ImportProcess" [_thread_in_native, id=31253, stack(0x0000000042a5e000,0x0000000042b5f000)]

siginfo:si_signo=SIGBUS: si_errno=0, si_code=2 (BUS_ADRERR), si_addr=0x00002aaac2224af1

Registers:
RAX=0x0000000000000000, RBX=0x000000005470d9e8, RCX=0x0000000000000070, RDX=0x00002aaac8b62b30
RSP=0x0000000042b5be80, RBP=0x00002aaac2224ad4, RSI=0x00000035291529e0, RDI=0x00002aaac80001e8
R8 =0x0000000000000000, R9 =0x0000000000000000, R10=0x00002aae378c5418, R11=0x00002aae378c8e88
R12=0x00002aaac8b62af0, R13=0x000000005470b460, R14=0x0000000042b5bf10, R15=0x0000000000000029
RIP=0x00002aaaab03f031, EFL=0x0000000000010206, CSGSFS=0x0000000000000033, ERR=0x0000000000000004
TRAPNO=0x000000000000000e
Does your code or the third party code use native code (JNI)?
866439
I am also facing the exact issue. Did you find any solution for this?
802316
I had a similar problem with Java 6 update 18 when reading a truncated ZIP/JAR file.

Since using Java 6 update 23 and 25 I haven't had this problem.
866439
We have 1.5.0_22-b03 on testing environment and it is working fine. But same 1.5.0_22-b03 in production environment is having the issue.
1 - 5

Post Details

Added on Jun 28 2019
4 comments
161 views