30-character limit for identifiers with ASE 15.x?
"Jeffrey Zelt" <[email protected]> Thu, 27 Aug 2009 13:23:37 +0200
| Newsgroups | gmane.comp.python.sybase |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--===============2069684368345079991==
Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01CA2708.D2F7ED9F"
This is a multi-part message in MIME format.
------_=_NextPart_001_01CA2708.D2F7ED9F
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I have a problem where a Sybase.DatabaseError exception is thrown by the
python-sybase module when I execute a Sybase ASE 15.0.3 stored procedure
that contains a local variable with a name longer than 30-characters.
=20
Here is exact error text:
=20
Traceback (most recent call last):
File
"/home/jeffreyz/workspace-3.5/generate-client-test-data/src/generate_dat
a_run.py", line 11, in <module>
'--logging-stderr-on', '--logging-stderr-level', str(logging.DEBUG),
File
"/home/jeffreyz/workspace-3.5/generate-client-test-data/src/generate_dat
a.py", line 415, in main
generate_client(cursor, options)
File
"/home/jeffreyz/workspace-3.5/generate-client-test-data/src/generate_dat
a.py", line 271, in generate_client
'@op_AccountNumber': Sybase.OUTPUT(1)})
File "build/bdist.linux-i686/egg/Sybase.py", line 418, in callproc
File "build/bdist.linux-i686/egg/Sybase.py", line 695, in _start
File "build/bdist.linux-i686/egg/Sybase.py", line 709, in _mainloop
File "build/bdist.linux-i686/egg/Sybase.py", line 753, in _raise_error
Sybase.DatabaseError: Msg 103, Level 15, State 205, Line 13
The identifier that starts with '@tmp_HasFixedInitialCreditLimi' is too
long. Maximum length is 30.
Msg 103, Level 15, State 205, Line 14
The identifier that starts with '@tmp_HasFixedClearingCreditLim' is too
long. Maximum length is 30.
Msg 137, Level 15, State 1, Line 14
Must declare variable '@tmp_HasFixedClearingCreditLimi'.
=20
Notice that it is complaining that the name of the local variable
'@tmp_HasFixedClearingCreditLimit' is too long.
=20
This was a known problem with ASE 12.x. However, I compiled the
python-sybase module on Ubuntu 9.04 against:
=20
Linux Express Edition for ASE 15.0.3
=20
I have never installed a version of ASE 12.x, so I could not have
accidentally compiled against old libraries. The server on which the
stack trace above was created was running ASE 15.0.3 on Fedora Linux.
=20
Does anyone know why I triggered an exception for identifiers over
30-characters when all libraries involved seem to be for Sybase ASE
15.x?
=20
Is there a way to fix this problem so that no exception is thrown?
=20
Regards,
Jeffrey
=20
------_=_NextPart_001_01CA2708.D2F7ED9F
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-GB link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal>I have a problem where a Sybase.DatabaseError =
exception is
thrown by the python-sybase module when I execute a Sybase ASE 15.0.3 =
stored
procedure that contains a local variable with a name longer than =
30-characters.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Here is exact error text:<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>Traceback
(most recent call last):<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>
File
"/home/jeffreyz/workspace-3.5/generate-client-test-data/src/generate=
_data_run.py",
line 11, in <module><o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>
</span><span lang=3DNO-BOK =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>'--logging-stderr-on',
'--logging-stderr-level', str(logging.DEBUG),<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DNO-BOK =
style=3D'font-size:10.0pt;font-family:"Courier New"'>
</span><span style=3D'font-size:10.0pt;font-family:"Courier New"'>File
"/home/jeffreyz/workspace-3.5/generate-client-test-data/src/generate=
_data.py",
line 415, in main<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>
generate_client(cursor, options)<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>
File
"/home/jeffreyz/workspace-3.5/generate-client-test-data/src/generate=
_data.py",
line 271, in generate_client<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>
'@op_AccountNumber': Sybase.OUTPUT(1)})<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>
File "build/bdist.linux-i686/egg/Sybase.py", line 418, in =
callproc<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>
File "build/bdist.linux-i686/egg/Sybase.py", line 695, in =
_start<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>
File "build/bdist.linux-i686/egg/Sybase.py", line 709, in =
_mainloop<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>
File "build/bdist.linux-i686/egg/Sybase.py", line 753, in
_raise_error<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>Sybase.DatabaseError:
Msg 103, Level 15, State 205, Line 13<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>The
identifier that starts with '@tmp_HasFixedInitialCreditLimi' is too =
long.
Maximum length is 30.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>Msg
103, Level 15, State 205, Line 14<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>The
identifier that starts with '@tmp_HasFixedClearingCreditLim' is too =
long.
Maximum length is 30.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>Msg
137, Level 15, State 1, Line 14<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>Must
declare variable =
'@tmp_HasFixedClearingCreditLimi'.<o:p></o:p></span></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Notice that it is complaining that the name of the =
local
variable ‘@tmp_HasFixedClearingCreditLimit’ is too =
long.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>This was a known problem with ASE 12.x. =
However, I
compiled the python-sybase module on Ubuntu 9.04 against:<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal> Linux Express Edition for ASE =
15.0.3<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>I have never installed a version of ASE 12.x, so I =
could not
have accidentally compiled against old libraries. The server on =
which the
stack trace above was created was running ASE 15.0.3 on Fedora =
Linux.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Does anyone know why I triggered an exception for
identifiers over 30-characters when all libraries involved seem to be =
for
Sybase ASE 15.x?<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Is there a way to fix this problem so that no =
exception is
thrown?<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Regards,<o:p></o:p></p>
<p class=3DMsoNormal>Jeffrey<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
</div>
</body>
</html>
------_=_NextPart_001_01CA2708.D2F7ED9F--
--===============2069684368345079991==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
--===============2069684368345079991==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Python-sybase-misc mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/python-sybase-misc
--===============2069684368345079991==--