User Profile

umesh049 started a topic views on table having field text

in SQL Server

Mar 29 '08, 05:39 AM
views on table having field text

Hi

i have a table which has a field having text data type and i want to make a view

on it but convert this text data type in to varchar data type my main purpose.

is to transfer data from sql server to oracle using Heterogeneous Connectivity

and Heterogeneous Connectivity does not transfer fields having data type like

text, ntext.

thanks

See more | Go to post

umesh049 started a topic hetrogenious database connectivity error from oracle to sql server

Mar 24 '08, 11:54 AM

hetrogenious database connectivity error from oracle to sql server

hi

i am getting this error plz help me

Code:

i made a new listener and new odbc connection
which is working almost fine.
Hi my problem is almost solve except.
SQL> select count(*) from "Storemain"@shop;
select count(*) from "Storemain"@shop

*
ERROR at line 1:
ORA-00942: table or view does not exist
[Generic Connectivity

...

See more | Go to post

umesh049 started a topic ORA-12560: TNS:protocol adapter error

in Oracle

Feb 20 '08, 06:59 AM

ORA-12560: TNS:protocol adapter error

Hi i install oracle on my system but getting this error

Code:

C:\Documents and Settings\umesh>sqlplus sys/123456 as sysdba
 
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Feb 19 11:51:32 2008
 
Copyright (c) 1982, 2004, Oracle.  All rights reserved.
 
ERROR:
ORA-12560: TNS:protocol adapter error
 
 
and
 
 
C:\Documents and Settings\umesh>tnsping

...

See more | Go to post

umesh049 started a topic trigger error

in Oracle

Dec 27 '07, 11:59 AM
trigger error
hello

I want to update in one trigger the tables in to another schema but it doesn't work but when i select data from sql prompt it works fine.

can any body help me.

thanks.

Code:

CREATE OR REPLACE TRIGGER Product_Detail_TR BEFORE INSERT ON Product_Detail FOR EACH ROW DECLARE PRE_ITEM_ID NUMBER :=0 ; BEGIN select :new.Item_Id into

...
See more | Go to post
umesh049 started a topic deletion issue

in Oracle

Dec 26 '07, 08:58 AM
deletion issue

Hello,

I want to delete data from all the tables made in a schema.

but i got error.

"object REPORTS does not exist"

but when i search this table from user objects it does not exists.

can any body help me.

thanks

[CODE=oracle]DECLARE
query varchar2(700);
CURSOR cu_idx IS
SELECT TABLE_NAME FROM USER_TABLES...

See more | Go to post

Last edited by debasisdas; Dec 26 '07, 12:12 PM. Reason: Formatted using code tags
umesh049 started a topic disable system given name constraint

in Oracle

Dec 24 '07, 12:03 PM
disable system given name constraint
Hello

A check constraint SYS_C0011712 is system given name to the constraint but when i want to disable it. i can' t it please give me some solution.

thanks

Code:

SQL> SELECT CONSTRAINT_NAME, CONSTRAINT_TYPE FROM USER_CONSTRAINTS WHERE TABLE_NAME='SUBCATEGORY CONSTRAINT_NAME C ------------------------------ - SYS_C0011712 C PK_SUBCATEGORY

...
See more | Go to post
umesh049 started a topic execute immediate problum

in Oracle

Dec 24 '07, 06:37 AM
execute immediate problum

Hello,

I want to delete all the date of all the table in a scheman.

but i got error at execute immediate statement.

can any body help me.

thanks

[CODE=oracle]DECLARE
query varchar2(700);
CURSOR cu_idx IS
SELECT *
FROM user_tables;
BEGIN
FOR cur_rec IN cu_idx LOOP
query:= 'delete from ' || upper(cur_rec.t able_name)...

See more | Go to post

Last edited by debasisdas; Dec 24 '07, 07:17 AM. Reason: Formatted using code tags
umesh049 started a topic query problum

in Oracle

Dec 14 '07, 12:51 PM
query problum
hi

Code:

DELETE FROM orders WHERE order_id = :id;

can any body tell me what :id means in this query

and why and where we use : symbol
See more | Go to post
umesh049 started a topic bad bind variable trigger

in Oracle

Dec 13 '07, 12:00 PM
bad bind variable trigger

[code=oracle]

CREATE OR REPLACE TRIGGER "NEO".TEMP_ TR BEFORE
INSERT ON TEMP FOR EACH ROW
declare
c_id number:=0;
BEGIN
select :new_ID into c_id from dual ;
dbms_output.put _line(c_id);

End;
[/code]

i am getting the error

4/8 PLS-00049: bad bind variable 'NEW_ID'

basically i want to store :new_ID value into a...

See more | Go to post

Last edited by amitpatel66; Dec 13 '07, 12:20 PM. Reason: code tags
umesh049 started a topic bad bind variable trigger

in SQL Server

Dec 13 '07, 11:56 AM
bad bind variable trigger

CREATE OR REPLACE TRIGGER "NEO".TEMP_ TR BEFORE
INSERT ON TEMP FOR EACH ROW
declare
c_id number:=0;
BEGIN
select :new_ID into c_id from dual ;
dbms_output.put _line(c_id);

End;

i am getting the error

4/8 PLS-00049: bad bind variable 'NEW_ID'

basically i want to store :new_ID value into a variable for further proc...

See more | Go to post
umesh049 started a topic Service Name

in SQL Server

Dec 12 '07, 10:10 AM
Service Name

Hi

Can anybody tell me how to see the service name in sql server..

thanks

See more | Go to post
umesh049 started a topic what is library path

in SQL Server

Dec 12 '07, 09:41 AM
what is library path

hi all

can any body tell me what is library path in sql server and can u give me
a sample library path

thanks

See more | Go to post
umesh049 started a topic data transfer from sql server to oracle

in SQL Server

Dec 12 '07, 05:57 AM
data transfer from sql server to oracle

Hi all,

Can any body give me any idea about how i can bulk transfer data from sql server to oracle 10g

thanks

See more | Go to post
umesh049 replied to set serverout on problum

in Access

Dec 6 '07, 09:36 AM
thanks for u r reply

i think environment variable become disable when we broke and reconnect to the
server but here connection is maintained.

so why this is happening.

if it then how to make it on every time i recompile the package.

thanks

See more | Go to post
Leave a comment:
umesh049 replied to Materialized Views in Oracle

in Oracle

Dec 6 '07, 04:59 AM
hello sir

i have also send one more question can u give answer of that question

thanks

See more | Go to post
Leave a comment:
umesh049 started a topic set serverout on problum

in Access

Dec 5 '07, 04:47 AM
set serverout on problum

hi all,

i made a simple package before executing the package i make set servrout on.

but next time when again i compile and execute the package again.

I again need to do set serverout on.

this is very irritating can any body help me

thanks.

See more | Go to post
umesh049 started a topic Materialized Views in Oracle

in Oracle

Dec 4 '07, 06:34 AM
Materialized Views in Oracle

hi all

can any body tell me the why we use materialized views in

oracle

thanks
umesh

See more | Go to post

No activity results to display

Profile Sidebar

views on table having field text

hetrogenious database connectivity error from oracle to sql server

ORA-12560: TNS:protocol adapter error

trigger error

deletion issue

disable system given name constraint

execute immediate problum

query problum

bad bind variable trigger

bad bind variable trigger

Service Name

what is library path

data transfer from sql server to oracle

Leave a comment:

Leave a comment:

set serverout on problum

Materialized Views in Oracle