logs archiveIRC Archive / Freenode / #oracle / 2010 / February / 12 / 1
fritzwinderlodge
hi
hi everybody, i have a weird question, i need an older version of Oracle 9i solaris, looking in google says that the only way to get it is in Metalink, but i need to have that version license or i can use another one lets say 10g ?
LFC_fan|inactive
Will setting up Oracle Developer Suite would be simple enough in Oracle Linux Enterprise Desktop?
sidh
Greetings gentlemen
RuslanPopov
re ppl
I have 10xe and it writes 'exceed limit 4gb'
I've looked at its web interface, total 5.2GB free 2.1GB
what parameter does Oracle mean as limit?
the size of all datafiles?
stede
hi, i have a function which expects an "table of number"-array as parameter, how can set the numbers as table in the query .. if it's not detaield enough i can paste an example
idle_task
Hello
If you don't specify "next <somesize>" when creating a datafile, what is the default size?
stede
i try to profile a function (pipelined) - but i cant execute theproposed code: PLS-00653: aggregate/table functions are not allowed in PL/SQL scope :-/ what to do?
tried with sqldeveloper
idle_task
ORA-24173: nested query not supported for rule condition
Nnnoooooo :('
In PL/SQL, what is the equivalent of a "continue;" in a for loop;
s,;$,?,
roote
i'm having a problem importing an expdp dump from a user (oracle schema) which contains XMLType tables created from .xsd schemas. The import using impdp never ends and CPU is at 100%. has anyone ran into this problem?
         

idle_task
Grrrr
I cannot do a simple PL/SQL function :(
stede
hi, i have a function which expects an "table of number"-array as parameter, how can set the numbers as table in the query .. if it's not detaield enough i can paste an example
idle_task: check this? http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/controlstructures.htm
siamba
newbie !
idle_task
OK, I have created my function, but now I have a problem, I cannot test it...
http://www.pastebin.ca/1794475 <-- how do I test that with a "select ... from dual"?
Is there a way to print a boolean as a string or whatever?
Does to_string work for booleans
s,$,?,
Question
Does the authid definer also work on functions?
bcom
.
cmug
begin.. define foobar = 11 \ select &&foobar from dual; end; why does it not work and throws a ORA-00900 instead?
\ is a newline
oh declare
stede
hi, i have a function which expects an "table of number"-array as parameter, how can set the numbers as table in the query .. if it's not detaield enough i can paste an example
idle_task
cmug, what if the define is outside of the begin? It's an sqlplus command after all, not a PL/SQL command
RuslanPopov
as far I know, define couldn't be inside pl/sql block
idle_task
RuslanPopov: that's what I surmised too, but I'm not sure
RuslanPopov
you may define variables before pl/sql block, then use these variables inside on, they will replaces by current values when block is executed
idle_task
Uhm
insert into atable values('something', '');
The second argument is taken to be null??
How do I insert an empty string instead?
Ohwell, nevermind, I have found a workaround
Question, is it possible to put a constraint when inserting into a table that a column should NOT have certain values?
Xgc
idle_task: That's called a table check constraint... or you could use a trigger.
idle_task: http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg05itg.htm
idle_task
Xgc: I could make it to work, thanks!
I must be off, now
Have fun
mastro
I need to convert a column of a table from string to timestamp. so i have to use the to_timestamp function and to alter that table. But I don't know which is the best way to do it, should i create a new temporary table? and how do I make sure the operation is atomic? (either commit all the conversion or nothing)
RJarett
why not add a new column, update new column, delete old column
or use dbms_redefinition
mastro
RJarett, i'll do some test thanks
josemoreira
im encountering "PHP has encountered an Access Violation at 028B9733" while reading LOB's, with PHP 5.2.6, anyone using PHP ?
RJarett
anyone here have a DD on an oracle box that can help me test something w/ rman?
datadomain i mean
anyone here use netapp w/ pamII modules?
« prev next »