Maximun length of parameter name in oracle

  • Thread starter Thread starter Popman
  • Start date Start date
P

Popman

Hi guys,

I met a issue that is about the lenght of the parameter name.

I'm using Oracle as back-end database, though I'm not familiar with oracle.


I'm using the following code to pass a parameter:
Dim objOracleParameter As New OracleParameter(parametername, value),
where the length of parametername can not be greater than 29.

I was wondering that is it the fixed limit of oracle or the DBA guy set this
limit?
Or any other possiblitis?

Any points would be appreciated.


popman
 
¤ Hi guys,
¤
¤ I met a issue that is about the lenght of the parameter name.
¤
¤ I'm using Oracle as back-end database, though I'm not familiar with oracle.
¤
¤
¤ I'm using the following code to pass a parameter:
¤ Dim objOracleParameter As New OracleParameter(parametername, value),
¤ where the length of parametername can not be greater than 29.
¤
¤ I was wondering that is it the fixed limit of oracle or the DBA guy set this
¤ limit?
¤ Or any other possiblitis?
¤
¤ Any points would be appreciated.

I believe the column name length is limited to 30 characters. This is an Oracle limitation.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top