Maximun length of parameter name in oracle

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
 
P

Paul Clement

¤ 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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top