Hello all,
I've used sqlite3 .read command to read in an SQL file from (exported via TOAD)
Oracle that contains TCL scripts.
The .read worked fine, but now I'm noticing that my multi-line scripts are not
running properly on the shell when I retrieve them from the sqlite table.
I notice that somehow extra newlines were added or some other control chars.
The original scripts in the exported SQL file are fine and can be run directly
on the shell.
Do I need to do something to properly import/store TCL scripts with backslashes
and newlines into SQLite??
still new to sqlite...
Thank you for any advice!
Below is the script from the SQL file:
set ver 7.1
set managedElementName \
[NamingAttributes_T $ver \
[NVSList_T $ver \
[NameAndStringValue_T $ver \
"EMS" \
"uuuu" \
] \
[NameAndStringValue_T $ver \
"ManagedElement" \
"IN_CN4200_22" \
] \
] \
]
set tpLayerRateList \
[LayerRateList_T $ver \
]
set connectionLayerRateList \
[LayerRateList_T $ver \
]
set how_many \
"1000"
if [catch {getAllPTPs $thread $managedElementName $tpLayerRateList
$connectionLayerRateList $how_many tpList tpIt} err] {
puts stderr "getAllPTPs failed, err = $err"
}
Below is the return from the select off the sqlite db:
set ver 7.1
set managedElementName \
[NamingAttributes_T $ver \
[NVSList_T $ver \
[NameAndStringValue_T $ver \
"EMS" \
"uuuu" \
] \
[NameAndStringValue_T $ver \
"ManagedElement" \
"IN_CN4200_22" \
] \
] \
]
set tpLayerRateList \
[LayerRateList_T $ver \
]
set connectionLayerRateList \
[LayerRateList_T $ver \
]
set how_many \
"1000"
if [catch {getAllPTPs $thread $managedElementName $tpLayerRateList
$connectionLayerRateList $how_many tpList tpIt} err] {
puts stderr "getAllPTPs failed, err = $err"
}
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
