oracle: I do not know how to correct the mutation activation error ORA-04091

I am learning Oracle SQL, but when I deal with triggers, I find an error that prevents me from updating the values ​​in that table.

The mistake is:

error ORA-04091: the USER.LINEAS table is mutating, the activator / function may not see it ORA-06512: in "USER.TRG_UpdateAcquired", line 5 ORA-04088: error during the execution of the activator & # 39; USER.TRG_ACTUALIZARPEDIDO & # 39;

I learned about that, but I can not find a solution or understand for myself what the problem is.

CREATE OR REPLACE THE TRIGGER trg_update ordered
AFTER INSERTING OR UPDATING OR DELETING IN LINES
FOR EACH ROW

TO DECLARE
sumImportLineas NUMBER: = 0;

START
SELECT SUM (AMOUNT) IN SUMAImportLINES OF LINES WHERE NUMBERED =: NEW.NUMPED;
UPDATE ORDERS ped SET ped.TOTAL = sumaImporteLineas WHERE ped.NUM =: NEW.NUMPEDIDO;
FINISH;

Thank you!

hierarchy – QUAD check box needs

I have read discussions about three-state check boxes, and even these are controversial: we have an even more complex problem with our software. We need 4 options and we can not find the best way to do it in a logical way. I have read again and again that a parent should not be selectable without selecting a child. For us, this is simply not true. Show the hierarchy below. A user can be a member of the father, or any of the children, but not both. We need a way to select check boxes to filter and locate users in any of these scenarios:

1) Father ONLY (since they can not be members of the children's organization)
2) Child ONLY (since being in a children's organization does not mean that you are a member of the main organization, simply that your organization informs the parent)
3) ALL children (without parents: there may be up to 20 children, so the individual selection of each one takes too long)
4) ALL – parents plus children

This problem arises again and again, even with the option of three states checkbox, we still do not have an easy way to toggle between these options. I would appreciate any idea no matter how random it is! We train our clients specifically in all the elements of our system, so, if it is not intuitive at the moment, the time-saving functionality in this case is more important than the additional training.

Thank you!

sample hierarchy

Recover Bitcoin Wallet information

I sent some bitcoins (worth around 1000 usd) to one of my wallets and I can not remember which wallet it was. Now I'm checking my wallet and I see that the balance is still there. Can someone tell me how I see the wallet information using the wallet address (3CGphwQHf5QvK6dMrLcLQvQNCuBsc85T5k) or the name of the wallet (1fac700f695d9d63). Anyone who has helped me access my wallet will be rewarded!

a data set of several csv files

In a folder I have many csv files, all sharing an identical header. I can use Semantic importance to produce a Data set of each one and then Join these in one Data set. Is that the correct way to proceed? Or does WL admit in some way a massive reading (like, for example, the R bulk reading package)?

Is there any spell only for sorcerers officially in Pathfinder?

In D & D 3.5, many of the "Dragon-something" reference books had spells that were in Sorcerer's spell list, but not in Wizard's. Some of them were of double purpose, others touched the draconic nature of the sorcerer, etc.

Are there spells like that officially in Pathfinder? Spells only for sorcerers, preferably interacting with their blood line powers? I understand that they are not so much necessary because Sorcerer now has his own treats, but I'd still like to know.

Problem when searching for them: even in D & D, they were listed as spells "Wizard / Wizard", with "spell only sorcerer" in small print. So this is not something that can easily filter. Or, if I can, I do not know how.

I tried Google "only sorcerer" on d20pfsrd.com but I only got results from Sorcerer's options: beyond the bloodlines. Copyright 2011, Super Genius Games; Author: Owen K.C. Stephens and I do not know if it is a balanced reference book, allowed in organized games, etc. I doubt it's in the official Pathfinder rules state, but those are all the results I found.

Globo.Tech | MSP based in Canada | It offers servers / infrastructure management and beyond.

GloboTech Communications offers Premium Management solutions.

As a support-oriented company with more than 19 years of experience, we have a proven track record of managing our clients' infrastructures. It can be from a single server configuration to a more advanced private or cluster cloud infrastructure.

Being an administration service provider, we can offer our administration services even to external networks / data centers.

Here are the offers for our management services:

The Premium Management Plan covers:

Support 24/7/365
SLA 100% network uptime *
100% uptime *
Replacement hardware 1 hour SLA *
25 events per month of system administrator support upon request
Recharge OS for free
Extended management options through the Customer Portal *
DDoS protection up to 10 Gbps (unlimited time) *
Monitoring of the service with Pro-Active Response by our support team
Monthly management reports
Health monitoring of RAID and HDD
Operating system and security updates
Managed backup with 100 GB backup space
Migratory assistance

Our VIP Management Plan:

Support 24/7/365
SLA 100% network uptime *
100% uptime *
Replacement hardware 1 hour SLA *
50 events per month of system administrator support on request
Recharge OS for free
Extended management options through the Customer Portal *
DDoS protection up to 10 Gbps (unlimited time) *
Monitoring of the service with Pro-Active Response by our support team
Monthly management reports
Health monitoring of RAID and HDD
Operating system and security updates
Managed backup with 1TB backup space
Migratory assistance
Control panel included
SSL Certificate
Firewall optimization
Anti-Spam filter

* Using our network infrastructure.

Here are some reasons to choose us:

In the business for over 19 years!

We are not going anywhere! We have been helping companies around the world since 1999.

Support 24/7/365

Within the company, our client has 24-hour assistance. Know that we will be there to help you when you need it most.

100% network availability

Our network has been designed to be completely redundant and very robust. Do not lose money due to downtime. Connect to the GloboTech network now!

Redundant network

All the equipment has been configured in a redundant capacity to guarantee the maximum operating time.

Network capacity

Our network is connected with a capacity of more than 100 Gbps from Tier1 and Premium suppliers. We do not sell excessively to our network and we are constantly adding a new uplink to guarantee capacity, speed and robustness.

Optimized routing

Connected to Top Tier providers, all connected by uplinks of 10 GigE for a total of more than 100 Gbps of redundant Internet access, GloboTech Communications has implemented an optimization system that can guarantee incredibly fast network traffic at the same time that respects your SLA of 100% network uptime.

Oriented and optional server management support.

Customers with little knowledge of server administration can be assured that our support team will be there to help them with any problems they may encounter. No matter what you need, we will be there to help you.

SLA hardware replacement

We understand that downtime is unacceptable! That is why we guarantee to change any defective hardware within 4 hours.

Contact Us
Sales: sales@globo.tech
Visit our website: www.globo.tech

Why does Donald Trump continue to attack the Mueller Report on Twitter and declare him totally exempt from the crimes?

Maybe because it is more of a piece against Trump than the results of a supposedly detailed investigation.

The bias is obvious. For example, if a person is badly done in some way and has an association with Trump and Clinton, then only the link to Trump is mentioned.

The same goes for people who have ties to Russia and who also work for the FBI. If they can be used to defame Trump, only his link to Russia is mentioned.

Mueller uses media articles to back up his claims, not to mention that the article happened because they leaked the details to the media.

There is a lot to criticize.

.

Weapons – How does the coating of a spear affect Mitral?

I wondered how a spear's cloak with Mithral would affect it. Mitral weapons are lighter than their normal properties, so how would a weapon with special property affect a mitral? I do not know if I am answering my own question, but would the spear only have the versatile property? If the spear had versatile property, what dice would you throw for attacking with one hand?

mobile – Navigating a double top bar

I have encountered a UX problem in a site I am designing. I feel there is an obvious solution but I have trouble finding it.

I have a site that has a sticky global bar. In the middle of the site, I have a tabbed browsing component. There are 3 tabs and the windows of each one contain a kind of extensive content.

I feel that my users will want to be able to navigate between these tabs without having to slide the page again.

Obviously I do not want to duplicate horizontal sticky bars. I can not replace or edit the global bar at all.

I'm thinking of a collapse to the side option. Or maybe turn it into a carousel with sticky arrows left / right?

Design proposal

icloud – Shortcuts: save a file to a specific folder that is NOT '/ shortcuts /'

I'm trying to create a shortcut from the action sheet to save a file to a particular iCloud Drive / Files folder. However, inside the options for the action "save file" in the shortcuts only allows me to save in the directory '/ shortcuts / & # 39 ;. How can I change this to be able to specify a file path that is not inside '/ shortcuts / & # 39 ;?

enter the description of the image here