logs archiveIRC Archive / Freenode / #oracle / 2010 / April / 15 / 1
DiscordianUK
what version of pro*c and what linux distro?
eoliva
DiscordianUK, is a Debian Etch with Oracle Standard 10.2.0
EFFINBUCKY
hello
anyone familiar with forms builder for oracle'??
i made the sequence with sql+
but when I go use it, it acts like it isnt there
suggestions?
lmfao nevermind
evne though noone answered
i'll explain for those that saw this
well i thought i was on the correct schema when i created the sequence and i was like wtf?
well i created the sequence in the right schema and it worked
yes I am dumb
Junior
yello ;)
meteo1974
good morning oracle guys
how can i use OLE Irems or ActiveX controle in Developer9i AS
10x
deebo
i need help getting details about a stored procedure, what kind of sql query do i need to get its definition?
it has 5 params, varchar, varchar, out-refcursor, out-varchar, out-number
i just need to refcursor
cofeineSunshine
sys_refcursor
deebo
so how do i call it :)
call proc('val','val', out, out, out), having problems with the out params
its proc(varchar,varchar,out cursor,out varchar,out number)
KeiKurono
morning
         

deebo
no idea how to call it, just keeps saying "wrong number of parameters or wrong types"
mgolisch
had to go yesterday
so ill ask again
what should i use for a general datastorage filesystem shared between my rac nodes?
ocfs2 or gfs
or something else
?
KeiKurono
this chan is dead...
meteo1974
Hi, anyone can help me??
I develop a form using Devloper9i AS, oracle 9i, Winxp
I need to use items like “ActiveX Control, OLE Container, Sound “ but they are marked as obsolete by Developer9i AS;
so how can I use like this type of items when I establish a form design “.fmb”
thanx a lot
mgolisch
someone said i should use acfs but we are not going to install release2 so ill have to stick with either ocfs2 or gfs
what do you people use?
this filesystem is to be used to place csvfiles there to be loaded into the database and for outputing data from the database
TheBonsai
11g2 client, installation using responsefile, it complains that the orainventory is empty/invalid. of course it is empty... it's the first/only oracle product to be installed there
anybody can think of a fix?
mac-
hello
I have problem as here
http://pastebin.com/TS3N84jJ
why there is Statement ignored error ?
ok I see now
will kill this guy who wrote it!
xenoterracide
(Action) grumbles
uberspaced
If I have an spfile, and I need to set something like nls_length_semantics, how do I go about doing it?
The installation software created a nice DB by default, but now I need to modify ~nls settings and complex_merging and what not
and I want those changes to remain permanent across startups / shutdown.
Something like this: ALTER SYSTEM set nls_length_semantics='CHAR'; seems to work
but NLS_SORT seems to be session based.
ZaiS
scope=spfile
Dormir
the default is scope=both. if it's a parameter that can't be modified while the system is running, then you'll need to use scope=spfile
uberspaced
Now I'm slightly confused; if the procedure is kind of drawn out, what documentation should I follow?
I've used alter system for a couple of nls things
but I don't know if that gets saved to my spfile.
Dormir
not really drawn out
if you're using an spfile, what I said holds true
uberspaced
I don't understand where i'd use "scope=spfile"
when I start the thing up?
dsdel
alter databse <param> = <value> scope=spfile;
Dormir
your change was written to the spfile and applied to the current running system. you can check this by creating a pfile from your spfile
uberspaced
ah. ok.
alter database nls_length_semantics = CHAR scope=spfile
ORA-02231: missing or invalid option to ALTER DATABASE
Dormir
system
uberspaced
ah.
Dormir
alter system set <param> = <value>
         

uberspaced
ok, that one worked.
Dormir
if you want it applied right away, use scope=both
if you want it applied on the next bounce of the database, use scope=spfile
uberspaced
I see.
Dormir
some parameters can't be changed immediately. for those, you have to use scope=spfile
uberspaced
I think I understand. this is interesting.
many thanks for your help.
xenoterracide
is the directory that's created after unpacking the zips required at all past install?
I suspect no.... but I don't want to rm it not being srue
sure*
lord1234
test
aaah it wanted me to register
anyone work with ADO and Oracle? http://stackoverflow.com/questions/2646156/ado-execute-not-reading-a-line-of-sql-code
markl_
is there anything on linux that works like aquadata studio?
preferably gpl but i'll consider anything
samble
does burleson hang out here
or is he too cool for irc
TheBonsai
he's busy with copy&pasting docs to his pages ;)
markl_
hmm, no idea about a simple DB client app to test my connectivity to Oracle? how well does Oracle SQL Developer work?
TheBonsai
to TEST the connectivity?
sqlplus.
markl_
well there is someone here with a mac who uses something called Aquadata Studio
it looks like an easy way to have a bunch of connections set up to test out
but i am more of a command line person, hmm
Dormir
never seen Aquadata Studio. a simple cli = sqlplus. a simple gui = sqldeveloper
or free TOAD or TOra
markl_
Dormir: cool, thanks, i'll give it a try!
are you ready to go to sleep or something? where'd you get the nick?
codingrobot
i'm working on a .NET app which writes unicode strings into nvarchar2 field. on my dev. machine everything is ok, but the production machine in china can't manage to write correct unicode chars. i wrote a small app quering nls_session_parameters and they are equal on the both machines (german). any idea on where the problem could be?
Shootdown
hi
how I can simulate a "
ORA-02055:
distributed update operation failed; rollback required
"
samble
markl_: i used aqua data studio for a while
just switched to dbvisualizer this week actually
thecolor3
ORa-03114 error coming up. Can't figure out why and websites arent giving any info
Dormir
what are you doing when it occurs?
thecolor3
Dormir: connecting via odbc from delphi 2010 but whats weird is dbexpress works just fine
TheBonsai
is dbexpress using the very same odbc connector?
dsdel
TheBonsai: if the alertlog/listener is empty I would say your driver is fail
or your coding :)
TheBonsai
or your nick completion
dsdel
but therefor it's delphi and not c++ I think the driver
er no nickcolor, sorry
TheBonsai
:)
dsdel
thecolor3: backlog
TheBonsai: evil when 2 ppl have nearly the same nicklength and same color :D
TheBonsai
easy to make a difference: a bonsai is smaller :)
dsdel
hmmm
7color TheBonsai 2
:D
I always forget how nickcolor is working
btw. TheBonsai what is your 'relation' to oracle? :)
TheBonsai
i don't care, it "usually" works automatic here, i.e. no duplicates
dba
markl_
samble: cool how do the 2 compare ?
dsdel
color TheBonsai 4
err
it's to late...
TheBonsai: linux right?
TheBonsai
time for a bed :)
markl_
i pretty much stick to perl, and rlwrap sqlplus :)
TheBonsai
yes, mostly linux. why?
dsdel
nah need to finish some coding first :D
TheBonsai: just remembered that we talked some days ago about platforms :)
Shootdown
how I can simulate a "
ORA-02055:
distributed update operation failed; rollback required
TheBonsai
dsdel: aaah i remember :)
dsdel
ye I was that windows guy :D
TheBonsai
dsdel: well, when you google me, i guess you won't find much windows ;)
dsdel
Shootdown: dunno sorry :D perhaps there is some sample inside oracle doc for doing it
thecolor3
TheBonsai: well the coding works fine, I even tried without having any calls to it just a plain connect, using delphi and it fails, however. if I use dbexpress it works just fine regardless *shrugs*
Shootdown
dsdel: thanks
dsdel
thecolor3: try another connector
Shootdown: sorry but I really can't imagine hoe :/ only update on 2 tables with second table lock and on wait remove the datafiles :D
samble
markl_: dbvisualizer is way cheaper and very nice
TheBonsai
hey that was a nice idea...
(Action) googles for himself
dsdel
first sap system updated with windows updates...
TheBonsai
argh. several people named like that
dsdel
next update cycle will be the oracle patches from today
TheBonsai: haha :D
I love that also...
samble
also you can run pl/sql straight from the normal editor
which i could not figure out how to do in aqua data studio
other than the price they're very similar
TheBonsai
dsdel: and it only makes sense as "TheBonsai" (in doublequotes), otherwise you feel like a gardener
hehe
dsdel
hehe TheBonsai googled after your real name with nick or just your nick?
TheBonsai
just the nick. Thebonsai (without quotes) just brings bonsai (tree) pages :))
dsdel
I can imagine :)
Results 1 - 10 of about 183,000 for thebonsai. (0.24 seconds)
TheBonsai
4,510 for "TheBonsai". (0.18 seconds)
a small difference
dsdel
TheBonsai
money talks
dsdel
ye
larry needs a new yacht
TheBonsai
heh
thecolor3
I found out why it was not working oracle 11g support is taken out of bde >.<
Nunovsky
hey
TheBonsai
m00
MxxCon
hey folks. is there some guidelines/best practices how to partition os filesystems on servers that will run 11gR2 rac?
(running oel5.5)
TheBonsai
oO RAC without ASM is hackish :)
« prev next »