topic Re: Exception while executing a select statement. in Application Development and Automation Discussions

Exception while executing a select statement.

Former Member — Wed, 14 Mar 2007 14:09:08 GMT

Hello All,

I get an exception:

"CX_SY_NO_HANDLER triggered

An exception with the type CX_SY_OPEN_SQL_DB occured but was neither handled"

Here is the select statement:

select single empneededby from hrp9007 into start_date

where OBJID = REQUISITION_NUM .

Can anybody tell me whats goin on here.

Thanks

Srinivas

Re: Exception while executing a select statement.

Former Member — Wed, 14 Mar 2007 14:11:30 GMT

Hello Srinivas,

Just whether u r passing all the key fields in the select query:

select single empneededby from hrp9007 into start_date
where OBJID = REQUISITION_NUM .

Regards,

Vasanth

Re: Exception while executing a select statement.

Former Member — Wed, 14 Mar 2007 14:12:46 GMT

Hi Srinivas,

Check with the table name, bcoz when i am trying to open the table it is giving as table does not exist.

Regards

Haritha.

Re: Exception while executing a select statement.

Former Member — Wed, 14 Mar 2007 14:13:03 GMT

Is the declaration of start_date same as empneededby.

Re: Exception while executing a select statement.

Former Member — Wed, 14 Mar 2007 14:30:58 GMT

Thanks all for your replies, I was trying all options. But still same exception. One thing "passing all the key fields in the select query:" from Vasanth's reply. Could you guys be more specific about using all the key fields in a select query.

Thanks

Srinivas

Re: Exception while executing a select statement.

Former Member — Wed, 14 Mar 2007 14:33:08 GMT

Hello Srinivas,

If u r using select single u need to pass all the primary key fields of the table in the where condition then only it will correctly fetch the desired record

Thanks !!!

Vasanth

Re: Exception while executing a select statement.

Former Member — Wed, 14 Mar 2007 14:53:07 GMT

Hi Vasanth,

I have changed my query to include all the key fields.

select single empneededby from hrp9007 into start_date

where plvar eq '01'

and istat eq '1'

and begda le sy-datum

and endda ge sy-datum

and reqnr eq REQUISITION_NUM

and status eq '99'.

When I execute, nothing happens. what am I expected to see.

Thanks

Srinivas

Re: Exception while executing a select statement.

Former Member — Wed, 14 Mar 2007 15:01:18 GMT

Hello Srinivas,

In ur first post u have assigned OBJID to REQUISITION_NUM

But now u have changed to reqnr

select single empneededby from hrp9007 into start_date
where plvar eq '01'
and istat eq '1'
and begda le sy-datum
and endda ge sy-datum
and reqnr eq REQUISITION_NUM " Check here
and status eq '99'.
IF SY-SUBRC = 0.
" U r having data for the selection condn in the table.
ENDIF.

Regards,

Vasanth

Re: Exception while executing a select statement.

Former Member — Wed, 14 Mar 2007 15:15:17 GMT

Hi Vasanth,

I want to look for the contents of the table and randomly pick one row and put all the key field values in my select statement and see if I can pull one other filed value. How can I look into the contents of the table. I tired se11 (displays only fields). se16, its asking some values before I can execute the table to display ( the values am not sure of).

Thanks and Regards.

Srinivas

Re: Exception while executing a select statement.

Former Member — Wed, 14 Mar 2007 15:24:42 GMT

When I test the class (say am printing something). Where can I see the output after I test the method.

Regards

Srinivas