C / C++ / MFC

4-Mar-10 19:11

Hi all

I am trying to fetch data from ORACLE.Connection part is working.When i try to fetch the data then i am getting error.

Microsoft OLE DB Provider for Oracle Error: -2147467259
Data type is not supported.
Unspecified error

I am trying give some details.

Table

CREATE TABLE "SYSTEM"."TEST" ( "OID" RAW(16), "EVENTID" NUMBER NOT NULL ,
 "NAME" VARCHAR2(30) NOT NULL , "TABLE_OBJNO" NUMBER NOT NULL ,
 "USAGE" NUMBER NOT NULL , "ENABLE_FLAG" NUMBER NOT NULL , 
"MAX_RETRIES" NUMBER, "RETRY_DELAY" NUMBER, "PROPERTIES" NUMBER, 
"RET_TIME" NUMBER, "QUEUE_COMMENT" VARCHAR2(2000),
 "SUBSCRIBERS" "SYS"."AQ$_SUBSCRIBERS", "MEMORY_THRESHOLD" NUMBER,
 "SERVICE_NAME" VARCHAR2(64), "NETWORK_NAME" VARCHAR2(256),
 CONSTRAINT "AQ$_QUEUES_CHECK" UNIQUE ("NAME", "TABLE_OBJNO") VALIDATE ,
 CONSTRAINT "AQ$_QUEUES_PRIMARY" PRIMARY KEY ("OID") VALIDATE ) TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGGING

Through this way i am trying to fetch the data.

CString tabledetail="Select utl_raw.cast_to_varchar2("OID"),"EVENTID","NAME",
"TABLE_OBJNO","USAGE","ENABLE_FLAG",
"MAX_RETRIES","RETRY_DELAY","PROPERTIES","RET_TIME","QUEUE_COMMENT",
"SUBSCRIBERS","MEMORY_THRESHOLD","SERVICE_NAME","NETWORK_NAME" from system.TEST";
try
{
	pRecordset=m_pConn->Execute(_bstr_t(tabledetail), 0, adCmdText);
}
catch(_com_error pCE)
{
	CString error;
	error.Format(_T("\n%s Error: %ld\r\n%s\r\n%s\r\n"),(TCHAR*)pCE.Source(),pCE.Error(),(TCHAR*)pCE.Description(),(TCHAR*)pCE.ErrorMessage());
	AfxMessageBox(error);
}

Please help me where i am wrong.

Garth J Lancaster4-Mar-10 22:04

4-Mar-10 22:04

I would look at

MsmVc wrote:
"SUBSCRIBERS" "SYS"."AQ$_SUBSCRIBERS"

- Im not sure that has a mapping from Oracle to OLE DB - not sure what you do to get around it -
everything else you specify has raw, number, varchar2 etc which seem ok.

Do a test - remove the

MsmVc wrote:
"SUBSCRIBERS"

from the query

MsmVc wrote:
CString tabledetail="Select utl_raw.cast_to_varchar2("OID"),"EVENTID","NAME","TABLE_OBJNO","USAGE","ENABLE_FLAG","MAX_RETRIES","RETRY_DELAY","PROPERTIES","RET_TIME",
"QUEUE_COMMENT","SUBSCRIBERS","MEMORY_THRESHOLD","SERVICE_NAME","NETWORK_NAME" from system.TEST";try

and see if it chucks a farley then - if it works, thats the issue !

'g'

MsmVc4-Mar-10 22:13

4-Mar-10 22:13

yes you are right.I had check remove the "SUBSCRIBERS" column then it's working fine.But Can you tell me some different way to do that because we can't remove column.I think it's "SUBSCRIBERS" a use define data type.
If you have different idea then plz help me

Garth J Lancaster4-Mar-10 22:30

4-Mar-10 22:30

pretty sure you cant do anything with Oracle AQ through the OLE DB Layer - you might have to use OCI - you might want to check the Oracle dev site for what the .NET client offers as well

'g'

MsmVc4-Mar-10 22:35

4-Mar-10 22:35

thanks for vital information...

MsmVc4-Mar-10 22:41

4-Mar-10 22:41

one more problem when data type is LONG RAW.Then i am getting error.

Microsoft OLE DB Provider for Oracle Error: -2147217900
ORA-00997: illegal use of LONG datatype
IDispatch error #3092

Garth J Lancaster4-Mar-10 23:07

4-Mar-10 23:07

iirc, in Ora 8i and above, LONG RAW is deprecated, and they are a pretty restricted use data type anyway - the closest equivalent is a blob.

You would have to read the Oracle manuals on how to deal with them, I dont think OLE DB Maps them - leastwise a quick look doesnt show anything useful - possibly you might get a variable array of bytes back, up to 2 GB in length

have a look at using TO_LOB to go from a LONG RAW to a BLOB

'g'

MsmVc4-Mar-10 23:11

4-Mar-10 23:11

TO_LOB is a data type.

Garth J Lancaster4-Mar-10 23:15

4-Mar-10 23:15

bollocks !! its a function - see http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions185.htm[^]

but is inapplicable in your case "You can apply this function only to a LONG or LONG RAW column, and only in the select list of a subquery in an INSERT statement."

well, you seem smart enough - sure you'll figure it out

'g'

MsmVc7-Mar-10 18:33

7-Mar-10 18:33

How can i use this?
Wheb i am useing like this

INSERT INTO "SYSTEM"."DEMO" VALUES('6565',0.0,TO_LOB('0001'),5000.0,0.0051,'5665','57');

Then show error.

ORA-00932: inconsistent datatypes: expected - got CHAR

Please help me

HWND From Procedd ID

john56324-Mar-10 19:00

4-Mar-10 19:00

I want to get HWND from process id. Below function return correct HWND in XP but not in Vista and Win7.

How to get HWND in Vista?

HWND CQemuConfig::GetWindowHWND(DWORD dwProcessID)
{
	HWND h = ::GetTopWindow(0 );
	while ( h )
	{
		DWORD pid;
		DWORD dwTheardId = ::GetWindowThreadProcessId( h,&pid);

		if ( pid == dwProcessID)
		{
			return h;
		}
		h = ::GetNextWindow( h , GW_HWNDNEXT);
	}
	return NULL;
}

Adam Roderick J4-Mar-10 19:14

Adam Roderick J

4-Mar-10 19:14

I hope u checked the error code. Smile | :)

Величие не Бога может быть недооценена.

john56324-Mar-10 19:20

4-Mar-10 19:20

Actually this function returning some handle that is not related to desired window in vista.

I came to know when I pass windows HWND to message box to make it model.

In XP message box is model, but in vista it is modeless So I think HWND is not correct in vista?

Eugen Podsypalnikov4-Mar-10 19:21

Eugen Podsypalnikov

4-Mar-10 19:21

You could try to place and test the code
inside a service, that would be started by user SYSTEM... Smile | :)

(if you know the title or class (discovered by Spy) of your dialog,
you could try the function FindWindow(..) too Smile | :)

)

Check your definition of Irrationality[^] Smile | :)

1 - Avicenna
5 - Hubbard
3 - Own definition

john56324-Mar-10 19:37

4-Mar-10 19:37

I want to place the window at top,left corner..
any idea

Eugen Podsypalnikov4-Mar-10 19:46

Eugen Podsypalnikov

4-Mar-10 19:46

Your idea is fully correct:
you need the windows handle Smile | :)

(
Did you try your previous posted context (5 min waiting) with

while (!FindWindow(..) &&
       !WaitTimeLimit()) {
  Sleep(100);
}

)

Check your definition of Irrationality[^] Smile | :)

1 - Avicenna
5 - Hubbard
3 - Own definition

john56324-Mar-10 19:55

4-Mar-10 19:55

Could you give answer according to my problem / code?

I print the title of window, in vista I am getting different window title.
It means there are same process id for 2 process.

How to get correct one?

Eugen Podsypalnikov4-Mar-10 20:17

Eugen Podsypalnikov

4-Mar-10 20:17

You could pass the returned handle to the searching tool of Spy
to control and analyze the result Smile | :)

Check your definition of Irrationality[^] Smile | :)

1 - Avicenna
5 - Hubbard
3 - Own definition