Lukas Kahwe Smith wrote:
I talked to Christopher Jones (of Oracle fame) and Lorenzo (MDB2
maintainer). Its clear that the only named parameter supporting
database I know does not support dash inside named parameters. Its
also dangerous since it means that whitespace typos could have
serious hard to spot issues. I think a safe regexp for bound
parameters would look something like: /^[a-z0-9][a-z0-9_]{0,30}$/
Since I couldn't find any official reference in
the oracle documentation, I did further tests.
I can reproduce the following behaviour on two
different machines (intel P4 and Core2Duo):
- if the named parameter is all digits,
it must be < 65536 or I get an "ORA-01745" error.
- if the name starts with a digit,
only digits are allowed (ORA-01036)
- the hyphen ("-") is forbidden (ORA-01036)
- the name can't start with an underscore (ORA-01036),
but can contain it elsewhere
- the (alpha-numeric) name must be <= 30 chars(ORA-00972)
- trivia: some non-standard ASCII chars (àòùéèç#$!)
are considered valid, but not all of them (°§£)
HTH
Best regards,
--
Lorenzo Alberton
http://pear.php.net/user/quipo
________________________________________________________________________
Quipo Free Internet: sicuro e veloce senza costi di attivazione e senza
canone, 2 e-mail da 25 Mb, 150 Mb di spazio web e molto di più!
Registrati gratis: http://www.quipo.it
--
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
