SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB Mail SQLState=S1104 error

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB Mail SQLState=S1104 error
Author Message
Tom Spafford



Joined: 07 Dec 2005
Posts: 3

Post DB Mail SQLState=S1104 error Reply with quote

I had DB mail 1.3.02 running on a Win95 box against an Oracle 8i server. has been running flawlessly.

However, needed to move DBmail to a different box (Win 98SE). Installed and configured as original.

However, the same SQL procedures that sent mail with no problems now don't send, on DB mail, I get:

"SQLState=S1104 invalid precision value"

I *think* I installed the same version of DB mail that I had originally, but it is possible I inadvertantly "downgraded" the PC software.

Would this cause this?

help!

Wed Dec 07, 2005 2:34 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Re: DB Mail SQLState=S1104 error Reply with quote

Please provide the actual SQL query you use to send emails.

: I had DB mail 1.3.02 running on a Win95 box against an Oracle 8i server. has
: been running flawlessly.

: However, needed to move DBmail to a different box (Win 98SE). Installed and
: configured as original.

: However, the same SQL procedures that sent mail with no problems now don't
: send, on DB mail, I get: "SQLState=S1104 invalid precision
: value"

: I *think* I installed the same version of DB mail that I had originally, but
: it is possible I inadvertantly "downgraded" the PC software.

: Would this cause this?

: help!

Wed Dec 07, 2005 3:09 pm View user's profile Send private message
Tom Spafford



Joined: 07 Dec 2005
Posts: 3

Post Re: DB Mail SQLState=S1104 error Reply with quote

: Please provide the actual SQL query you use to send emails.

This query works:

SELECT send_mail('tespafford@hickok-inc.com',

'Test message',

'DB Mail test message from SQL statement',

'tespafford@hickok-inc.com')
FROM dual ;

This one does not:

SELECT send_mail('tespafford@hickok-inc.com',

'New Product Registration',

'(This is a test of a new Oracle database email utility)' || chr(10) ||

'The following online registration has been received.' || chr(10) ||

'Please review online at http://appserver.hickok-inc.com/webdb/product.r_csedit.show' || chr(10) ||

'Customer ID ' || custid || chr(10) ||

'Last name: ' || lname || chr(10) ||

'First Name: ' || fname ||chr(10),

'registrations@hickok-inc.com' )
FROM product.csreg
WHERE cdate IS NULL and rdate = TRUNC(SYSDATE);

From SQL Plus, the equivalent of the second query shows:

SQL> select custid,lname,fname from product.csreg where cdate is null and rdate=trunc(sysdate);

CUSTID LNAME FNAME
------------- -------------------- --------------------
AW5712210089 WINGETT ALEX

All of these used to work flawlessy before. My limited research seems to point to an ODBC problem? I am using ODBC connection in DB mail, after installed Oracle 8i client and configuring with Net8 easy Config.


Wed Dec 07, 2005 3:26 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Re: DB Mail SQLState=S1104 error Reply with quote

I cannot say for sure, but I think it is an issue caused by the ODBC driver. I researched on the Internet and found other people getting "sqlstate s1104" when running their queries using ODBC and not getting it when using native drivers and tools or pass-through queries. Can you try a different ODBC driver or set DB Mail to use native connection for Oracle.

: This query works: SELECT send_mail('tespafford@hickok-inc.com',

: 'Test message',

: 'DB Mail test message from SQL statement',

: 'tespafford@hickok-inc.com')
: FROM dual ;

: This one does not: SELECT send_mail('tespafford@hickok-inc.com',

: 'New Product Registration',

: '(This is a test of a new Oracle database email utility)' || chr(10) ||

: 'The following online registration has been received.' || chr(10) ||

: 'Please review online at
: http://appserver.hickok-inc.com/webdb/product.r_csedit.show ' || chr(10)
: ||

: 'Customer ID ' || custid || chr(10) ||

: 'Last name: ' || lname || chr(10) ||

: 'First Name: ' || fname ||chr(10),

: 'registrations@hickok-inc.com' )
: FROM product.csreg
: WHERE cdate IS NULL and rdate = TRUNC(SYSDATE);

: From SQL Plus, the equivalent of the second query shows: SQL> select
: custid,lname,fname from product.csreg where cdate is null and
: rdate=trunc(sysdate);

: CUSTID LNAME FNAME
: ------------- -------------------- --------------------
: AW5712210089 WINGETT ALEX

: All of these used to work flawlessy before. My limited research seems to
: point to an ODBC problem? I am using ODBC connection in DB mail, after
: installed Oracle 8i client and configuring with Net8 easy Config.

Wed Dec 07, 2005 4:48 pm View user's profile Send private message
Tom Spafford



Joined: 07 Dec 2005
Posts: 3

Post Re: DB Mail SQLState=S1104 error Reply with quote

I restored the old Win95 PC from an image I had (thoughtfully) made.

DB mail is up and running normally on that system and processing all emails as before.

I now have a chance to really compare the 2 machines to see what the differences are.

Wed Dec 07, 2005 4:53 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.