It is that time again...Time to go mingle with the best of the best, learn much, teach what I can, suffer information overload, have fun, enjoy life, and much much more...In short - time for ODTUG KScope13 \o/ \o/Hotel and flight has been booked half a year ago, passport and ESTA is current and valid, I'm ready to go!So the end of June I will be doing the following:
select convert('£','US7ASCII', 'WE8MSWIN1252')
create table baby as
select /*+ parallel (9) */months
ORA-12827: insufficient parallel query slaves
(requested 9, available 1, parallel_min_percent 9)
12827. 00000 -
"insufficient parallel query slaves available"
One for all the project managers to take note of - there's some tasks which
simply can't be done any faster by throwing more people/resources at them ;)
Ah, beautiful brain:
Where have you been all my life?
And where are you going?
Somebody wanted an example of how to capture the return value of a PL/SQL function in a PHP script running against the Oracle Database. The trick is embedding the call inside an anonymous block program unit, like a prior example that I posted on handling an OUT mode variable in a PL/SQL Procedure.
Here’s the sample PHP code:
1. Don’t forget always add NO_DATA_FOUND exception handling, when you doing “select into” in code which can be called as from PL/SQL, as from SQL.
A little example:
Suppose we need to create a function, which would call some procedure:
insert into data_you_thought_was_gone
as of timestamp
sysdate - interval '1' hour
Flashback to the rescue again!
alter table crumbly_cheese
move tablespace caerphilly;
You can't beat a classic cheese pun in SQL form ;)
select posts from sqlfail
PHP namespaces are new to PHP 5.3 (2012), but PHP class files have been around since PHP 5 was introduced. However, a couple students had problems creating working code from the many fragments published else where. Here’s my attempt to qualify it in a single post, running Zend Server Community Edition 6 and Oracle Database 11g.